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.
Solved! Go to 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.
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.:)
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!
Thank you, really appreciate it.