Convert month year to first day of month

[Saravanan13]

Hello,

I am looking to convert the below field in to 1st day of the month example : 10/01/2021

Input

10-2021 (mm-yyyy)

Output

10/01/2021

can anyone assist.

[SPetrie · Accepted solution]

You could use a formula to parse it to a date/time data type and then use a datetimeformat on it to put it into the desired output

datetimeformat(DateTimeParse([date],"%m-%Y"),"%m/%d/%Y")

Or, since it looks to mainly be in the format you want anyway, you can replace the dash with /01/ and it would also look like what you want.

replace([date],"-","/01/")

[Qiu · Accepted solution]

@Saravanan13 
We can also use the DateTimeTrim function, which is my favorite. 😁