Converting partial year and text to year/month

[betteratuno]

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! 

[Sho · Accepted solution]

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