Validations - Date Less than <value> ?

More

1 year 5 months ago #24832 by prashant

Validations - Date Less than <value> ? was created by prashant

Hi,

Is it possible to pass variable or field value to do the comparison ?If yes ? how?

The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More

1 year 5 months ago #24835 by Peter.Jonson

Replied by Peter.Jonson on topic Validations - Date Less than <value> ?

For this case we have compare values transformation function

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More

1 year 5 months ago #24855 by prashant

Replied by prashant on topic Validations - Date Less than <value> ?

Can I get an working transformation as an example , all my attempts to try this fails.

Please Log in or Create an account to join the conversation.

More

1 year 5 months ago #24856 by Peter.Jonson

Replied by Peter.Jonson on topic Validations - Date Less than <value> ?

If you you are working with dates you have to make sure that they are in standard ODBC format

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More

1 year 5 months ago #24863 by prashant

Replied by prashant on topic Validations - Date Less than <value> ?

Yes everything is in YYYY-MM-DD format

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More

1 year 5 months ago #24866 by admin

Replied by admin on topic Validations - Date Less than <value> ?

We have created a short video for you.

I hope you will find it useful

Mike
ETL Architect

The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.