Many strings in format yyyy-mm-dd , convert to date format dd-MMM-yy
- 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
Hi,
Is it possible to convert many columns from yyyy-mm-dd (these are strings) to date dd-MMM-yy in one formula?
Thanks.
Solved! Go to Solution.
- Labels:
- Custom Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wonka1234 yes use the datetimeparse and datetimeformat formulas in the multi-field tool and it should convert all the fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DateTimeFormat([_CurrentField_],"dd-MMM-yy")
doing this.. but literally getting that.. how to use datetimeparse here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @wonka1234 , use this formula in a Multi-Field formula tool, ticking all the fields you want changed.
datetimeformat(
datetimeparse([_CurrentField_],'%Y-%m-%d')
,'%d-%b-%y')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wonka1234 I mocked up an approach. The datetimeparse formula would be needed as you mentioned your dates were in a string format. So parse into a date format before using the datetimeformat formula to output into the format you need.
