Question
We to build a KPI which identifies the required date format MM/DD/YYYY
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.