Ternary operation to handle diff date formats
The source file contains Reporting Period value in diff date format.
Aug-2022
Aug-22
AUG 2022
August-2022
I am using the below ternary expression to handle the above mentioned date pattern....
Forum Discussion
Hi @UrsVinny ,
You can always extend the ternary operator with another nested ternary, but that could very easily become a complex and unsustainable expression.
I would recommend an expression library with a function that will check the date field for all possible formats.
That way you can easily add a new format in the future if needed.
Regards
