- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2024 09:30 AM
Hello!
I have a large set of dates that are a partial year and month, and would like to convert this to a final date of the month format. Examples:
Data I Have | Desired Format |
24-Apr | 2024-04-30 |
24-Aug | 2024-08-30 |
23-Dec | 2023-12-31 |
I've tried concat using LEFT( & RIGHT(
I'd like to try SUBSTITUTE, but not sure of the formatting. I'm also open to any suggestions
Thanks for your time!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2024 04:20 PM
Hello @betteratuno,
This is how to parse the date and get the end of the month
DATEADD(DATEADD(DATETIME_PARSE({DateText},"YY-MMM"), 1, "Months"), -1, "Days")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2024 04:20 PM
Hello @betteratuno,
This is how to parse the date and get the end of the month
DATEADD(DATEADD(DATETIME_PARSE({DateText},"YY-MMM"), 1, "Months"), -1, "Days")
