Converting Date Time
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The DateTime tool should help you to do this using the custom format of Monyy
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you this works!! I appreciate it 🙂