SOLVED
convert to only month and year from string
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
adarsh2608
8 - Asteroid
‎04-12-2022
08:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a number which is in 202201 how can i convert to date format ( year and month 2022-01 )
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
binuacs
21 - Polaris
‎04-12-2022
08:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
alexm06
8 - Asteroid
‎04-12-2022
08:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi adarsh2608,
As long as the date is always in the format yyyymm you could use Left and Right functions in a Formula tool to add a "-" to separate the year and month before using the DateTime tool to convert the field type to DateTime.
I've attached an example workflow.
Does that solve your problem?
