Help

1st of the month date formula

Topic Labels: Formulas
Solved
Jump to Solution
49 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

See Solution in Thread

3 Replies 3

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

Screenshot 2022-11-22 at 20.54.03

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