Datetime tool error

[SCK]

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.

[BradWerner · Accepted solution]

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.

[SCK]

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 · Accepted solution]

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]

Thank you, really appreciate it.