Ryan
1
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
5 Likes
Ryan
3
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
system
Closed
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.