Extract the first day of the month

[Ryan]

Hi team,
So I’m trying to extract the 1st day of the month, regardless of the user’s date format.

No matter what I try, it works only if the input format is MM/DD/YYYY.

e.g.
Input data 31/12/2023 → I expect it to return 01/12/2023 OR 12/01/2023 (doesn’t work)
Input data 12/31/2023 → does work and returns 12/01/2023.

Thanks!

[Jeff_Hager]

As long as your source date is a date column, you can use a math column to get the first day of the month.

Date-Day(Date)+1

[Ryan]

Magic @Jeff_Hager !

For the record, to find the last day of the month (also provided by the magician), use ((Now-DAY(Now)+15)+30)-DAY((Now-DAY(Now)+15)+30)