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
Best answer by Samuel Muvdi
View originalHello
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
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
