Date formating Issue

Question

Dear Community,

Would like to ask how can i change the date format as per screenshow below. Also, may i know how do we prevent the date result change to the format-  general number , ie 484730 when render it as CSV file?

Many thanks in advance.

Date Format.xlsx

atcodedog05 · Answer

@binu_acs Nice trick on using only the required part for DateTimeParse 🙂👍

binu_acs · Answer

@SH_94

DateFormat3.bak.yxmd

atcodedog05 · Answer

Hi @SH_94

Here is how you can do it.

Workflow:

Hope this helps : )

datefix.yxmd