Validating Dates
To change Validation Function properties double click on it
Is Date
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date |
| Properties |
Is Date Between
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date between two values |
| Properties | Default |
Is Date Less Than
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date less than value |
| Properties | Default |
Is Date More Than
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date more than value |
| Properties |
Is Monday, Is Tuesday, Is Wednesday, Is Thursday, Is Friday, Is Saturday, Is Sunday, Is Today, Is Yesterday, Is Tomorrow, Is Weekend, Is Weekday
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date value which belongs to a specific day of week |
| Properties | Same as ‘Is Date’ |
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
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date value which belongs to a specific month of a year |
| Properties | Same as ‘Is Date’ |
Is 1st Quarter, Is 2nd Quarter, Is 3rd Quarter, Is 4th Quarter, Is Current Quarter, Is Last Quarter, Is Next Quarter
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date value which belongs to a specific quarter of a year |
| Properties | Same as ‘Is Date’ |
Is Leap Year, Is Current Year, Is Last Year, Is Next Year
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date value which belongs to a specific year |
| Properties | Same as ‘Is Date’ |
Is Current Week, Is Last Week, Is Next Week
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date value which belongs to a specific week |
| Properties | Same as ‘Is Date’ |
Is Within Past Minutes, Is Within Past Hours, Is Within Past Days, Is Within Past Weeks, Is Within Past Months
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Date value within in past minutes etc. |
| Properties | Same as ‘Is Date’ |
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum