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
Solved! Go to 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