I'm having a hard time converting the following date time format. Hoping that someone could assist me.
2020-4-26 to Apr20
Thank you 🙂
Solved! Go to Solution.
The DateTime tool should help you to do this using the custom format of Monyy
Hi Brandon,
It does not match the exact format as my use case.
I have 2020-4-27 and your sample is 2020-04-27.
Are you still able to resolve using the format from my sample?
Thank you !
Yep! Even though your data looks like it is a date, technically it isn't in a date data type yet. You can use one date time tool to format to take your date in a string and convert it into an official date data type, and then use another date time tool to bring it back into a string in whatever format you would like.
Hi @henrymk5 ,
Let me know if this works for you.
Regards
Benn
P.S: In case this solves your query, kindly mark this as a solution.
Thank you this works!! I appreciate it 🙂