Skip to main content

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

Hi @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)


perfect! Thank you. - Wendy

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")

Reply


Terms & Conditions