Extract the first day of the month

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!

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
4 Likes

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)

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.