Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

1st of the month date formula

Topic Labels: Formulas
Solved
Jump to Solution
3679 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Wendy_Yelsik
6 - Interface Innovator
6 - Interface Innovator

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
Kamille_Parks
16 - Uranus
16 - Uranus

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)

Wendy_Yelsik
6 - Interface Innovator
6 - Interface Innovator

perfect! Thank you. - Wendy

Kamille_Parks
16 - Uranus
16 - Uranus

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