Page 1 / 1
Hi @dubbaka.dines12 ,
I think converting the string 'Creation date' to a Date with the desired Format should work, If the string does not correspond to the format, will return null, then checking if the result is null or not with a Case/When statement dould works
CASE
WHEN ISNULL ( TO_DATE ( 'Creation date column' , FORMAT ( '%m/%d/%Y' ) ) = 1 THEN 'incorrect'
ELSE 'correct'
END
Hope it helps
Javier
Hi @dubbaka.dines12 ,
I think converting the string 'Creation date' to a Date with the desired Format should work, If the string does not correspond to the format, will return null, then checking if the result is null or not with a Case/When statement dould works
CASE
WHEN ISNULL ( TO_DATE ( 'Creation date column' , FORMAT ( '%m/%d/%Y' ) ) = 1 THEN 'incorrect'
ELSE 'correct'
END
Hope it helps
Javier
Thanks for the help. It’s working
Regards,
Dinesh
Email : dubbaka.dinesh@hcl.com
Contact : 9000617170
bcid:image001.png@01D7BFCD.10B75450]
Glad to help 👍
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.