Is there a date formula to calculate the 1st of the month based on a date? For example, I want to calculate 11/1/2022 for 10/15/22, 10/5,22, etc. = Wendy
Solved
1st of the month date formula
+7Best answer by Kamille_Parks11
If you want a usable date rather than a string, you can do:
DATETIME_PARSE(DATETIME_FORMAT(DATEADD({Date}, 1, 'month'), "MM/YYYY"), "MM/YYYY")
+18Hi @Wendy_Yelsik - do you mean the 1st of the next month? If so, you can do this:
DATETIME_FORMAT(DATEADD(Date, 1, 'month'), 'MM/01/YYYY')
(You don’t need the middle field, I just displayed this to show how it was derived)
+27If you want a usable date rather than a string, you can do:
DATETIME_PARSE(DATETIME_FORMAT(DATEADD({Date}, 1, 'month'), "MM/YYYY"), "MM/YYYY")
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.