1st of the month date formula

[Wendy_Yelsik]

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

[JonathanBowen]

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)

[Wendy_Yelsik]

JonathanBowen:

DATETIME_FORMAT(DATEADD(Date, 1, ‘month’), ‘MM/01/YYYY’)

perfect! Thank you. - Wendy

[Kamille_Parks · Accepted solution]

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