Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Converting partial year and text to year/month

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
899 1
cancel
Showing results for 
Search instead for 
Did you mean: 
betteratuno
4 - Data Explorer
4 - Data Explorer

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 HaveDesired Format
24-Apr2024-04-30
24-Aug2024-08-30
23-Dec2023-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! 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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")

 

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

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")