Date Conversion (String to String)

[SYang1]

The below is in string format"

Jan 14 2020 8:11AM

Jan 21 2020 2:04PM

and from the above, i want to include the Day with the output as a string

Jan 14 2020 8:11AM --> Tue Jan 14 2020 8:11AM 

Jan 21 2020 2:04PM --> Tue Jan 21 2020 2:04PM

[Jonathan-Sherman · Accepted solution]

Hi @SYang1,

You could use the following formula:

DateTimeFormat(DateTimeParse([String],'%b %d %Y %I:%M%p'), '%a %b %d %Y %I:%M%p')

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan