Hi folks, I have a date format that I need to validate using a DG rule in Ataccama ONE. I don’t need to do anything with it, just validate that the format is as expected. Any ideas on how I can achieve this please?
Many thanks
DC
Solved
Java regex date formats and how to write dq rules for date patterns yyyy-mm-dd hh:mi:ss.ms
- Universe Traveller
Best answer by Samuel Muvdi
Hello
I recommend trying to do something like this with an advanced expression. It will turn your date to a string and see if its able to in that format, and if it doesn't return null, then its correct, it is of that type:
toString(date, 'yyyy-MM-dd hh:mm:ss') is not null
- Ataccamer
Hello
I recommend trying to do something like this with an advanced expression. It will turn your date to a string and see if its able to in that format, and if it doesn't return null, then its correct, it is of that type:
toString(date, 'yyyy-MM-dd hh:mm:ss') is not null
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.