This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If the year format is in yyyy form you can change your expression to [Month]+", "+[Year] (note the space after the comma) and then use the DateTime tool to format your string into a date. The DateTime tool can convert "Month, yyyy" format into a Date.
So if I am understanding you correctly, I should join the two string column (Year and Month) such that it reads "YYYY-MM" - but what is the DateTimeParse output I should use? Can you walk me through that formulation? THank you!
You haven't said anything about the day of the month, but as @MarqueeCrew said, if you format it as YYYY-MM-DD, then that can just be converted to a date. You could just add a '-01' to your year/month concatenation to supply the day if you don't have one.
If you only have the month and year, I would just use a Formula tool with this expression...DateTimeParse([ConcatDate],'%m-%Y')...and it will default to the first day of the month.