Welcome to the ADAPT Discussions board! Please use this location for general questions regarding the ADAPT program. For technical questions, please check out the Designer Discussions Board. For AFG general questions, please check out our new General AFG Discussions board!

ADAPT Discussions

Discuss and build your skills with others who have been impacted by COVID-19.
SOLVED

Stuck with a DateTime tool exercise

IS2003
6 - Meteoroid

Hello:

 

I would appreciate some guidance with getting from the date format listed on the left to the format listed on the right below.

 

IS2003_0-1604318110883.png

Thanks much. 

4 REPLIES 4
joshuaburkhow
ACE Emeritus
ACE Emeritus

This is how I would do it 😉 

 

joshuaburkhow_0-1604318604577.png

 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
atcodedog05
22 - Nova
22 - Nova

Hi @IS2003 

 

Additional to @joshuaburkhow method you use the below formula also to parse this date format.

DateTimeParse([Field1],"%Y:%m:%d---%H|%M|%S")

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

IS2003
6 - Meteoroid

Thanks Josh. 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @IS2003 

 

Cheers and Happy Analyzing 😀