Hi All,
toDate(Input, “yyyy/MM/dd”) function is not throwing null when I am passing value “1/1/1”. Input datatype is string.
can anybody help why it takes 1/1/1 as valid date value?
Regards,
Shefhali
Solved
toDate function in Ataccama
- Space Explorer
Best answer by AKislyakov
Hi
“1/1/1” under this format is read as “1st January 0001 AD”, which is a valid date, Monday.
You might want to add an additional rules, to validate that the resulting date falls within certain range, e.g. no older than a hundred years from now.
- Space Explorer
Also, Is there any function or method available to validate a date which datatype is string?
- Ataccamer
- Answer
Hi
“1/1/1” under this format is read as “1st January 0001 AD”, which is a valid date, Monday.
You might want to add an additional rules, to validate that the resulting date falls within certain range, e.g. no older than a hundred years from now.
- Space Explorer
Thank you team, i have added some other regexp to handle these special cases that I want to fail
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.