Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

1st of the month date formula

Topic Labels: Formulas
Solved
Jump to Solution
240 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")