Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Datetime tool error

SCK
8 - Asteroid

Hi all - I am trying to convert a string into Date using the Datetime tool. however, it is not pulling in the dtes correctly. Please someone help. My string is:

 

20190131

20190720

20190625

20190530

 

However, the Datetime tool is pulling in the format incorrectly. I have attached the workflow for your reference. Please help.

 

SCK_0-1599969750727.png

 

4 REPLIES 4
BradWerner
11 - Bolide

Hi @SCK!

 

You were super close! Just switch your format from yyyymmdd to yyyyMMdd. Let me know if this works for you or if you were expecting something different.

 

BradWerner_0-1599970088931.png

 

SCK
8 - Asteroid

Oh My God! Why did I not see it before.. I did scroll through the standard options, but somehow kept missing this. Thank you so much. It did work out.:)

BradWerner
11 - Bolide

No worries! I still put mm instead of MM occasionally.

 

Whenever I see all my dates with the month staying at 01 but the minute portion of a timestamp is present, I know I missed it.

 

Take care!

SCK
8 - Asteroid

Thank you, really appreciate it.

Labels