Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Conversion (String to String)

SYang1
6 - Meteoroid

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

 

 

1 REPLY 1
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @SYang1,

 

You could use the following formula:

 

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

 

image.png

 

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

Labels
Top Solution Authors