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 Format24-Apr2024-04-3024-Aug2024-08-3023-Dec2023-12-31I've tried concat using LEFT( & RIGHT(I'd like to try SUBSTITUTE, but not sure of the formatting. I'm also open to any suggestionsThanks for your time!

Solved

Converting partial year and text to year/month

+3

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:

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!

Best answer by Sho

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

+21

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