Help

Converting partial year and text to year/month

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
314 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")