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
@UrsVinny - Sorry I originally posted a little too quickly and didn’t validate my reply.
Here is a small sample pipeline using the Conditional snap to test if it’s a 2-or-4 digit year before doing the Date.parse()
Community 13660 - Date parsing_2022_10_19.slp (5.4 KB)
It’s pretty easy to add expressions in the Conditional. As a general rule, I typically revert to the Conditional snap when the ternary logic requires more than one test since ternary gets hard to decipher after just a couple levels.
Hope this helps!
