Cannot format date correctly to YYYY-MM-DD
Hi there,
I’ve looked at other articles addressing this but non has helped me so far.
Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD.
The date will always be populated.
I’ve trie...
Forum Discussion
Okay so the Date/Time Extractor is not available in our packs which is fine.
Using the expression provided, the date still doesn’t format properly.
The input date is 06/04/2021 but in the expression appears as 0021-06-04
I think the problem is that, ‘Due Date’ is passed down the flow already as a date with a dd/MM/yy format (two digit year - 21), so when you add your preffered format , yyyy-MM-dd it adds two 0’s in front - 0021. If that’s the case, you can try to add ‘20’ manualy before you parse and format the date.
Note that this won’t help you if your process has older dates, before 2000, but if I am right about the issue, than we are close to the solution.
