Validating Dates

Date validation rules in Advanced ETL Processor allow you to check whether date values meet specific conditions during data validation. Use these rules to validate date ranges, days of the week, months, quarters and years, or check whether a date represents today, yesterday, a weekday, a weekend, or falls within a specified period.

Download Advanced ETL Processor

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Is 1st Quarter, Is 2nd Quarter, Is 3rd Quarter, Is 4th Quarter, Is Current Quarter, Is Last Quarter, If Next Quarter

Checks if the data is a Date value which belongs to a specific quarter of a year

Is Current Week

Checks if the data is a Date value which belongs to a specific week

Is Date

Checks if the data is a Date

Is Date Between

Checks if the data is a Date between two values

Is Date Less Than

Checks if the data is a Date less than value

Is Date More Than

Checks if the data is a Date more than value

Is January, Is February, Is March, Is April, Is May, Is June, Is July, Is August, Is September, Is October, Is November, Is December, Is Current Month, Is Last Month, Is Next Month

Checks if the data is a Date value which belongs to a specific month of a year

Is Leap Year, Is Current Year, Is Last Year, Is Next Year

Checks if the data is a Date value which belongs to a specific year

Is Monday, Is Tuesday, Is Wednesday, Is Thursday, Is Friday, Is Saturday, Is Sunday, Is Today, Is Yesterday, Is Tomorrow, Is Weekend, Is Weekday

Checks if the data is a Date value which belongs to a specific day of week

Is Within Past Minutes, Is Within Past Hours, Is Within Past Days, Is Within Past Weeks, Is Within Past Months

Checks if the data is a Date value within in past minutes etc.

Advanced-etl-processor

Validating Dates

Download Advanced ETL Processor