Skip to main content

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

 

Hello @Delbert71!

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🇲🇲ss') is not null

Reply


Community Terms of Use & ConditionsCookie settings