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.

Date formula to show date of tthe first day for current month and year

Topic Labels: Formulas
487 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there -

Looking for a way to have a formula show the first of the month for the current month and year. I.e. the formula fields says 2/1/2022 when it is Feb, then when it is March 3/1/2022 and so on…it would update on the first of each month

Any help out there?

2 Replies 2

This formula can be written a variety of ways, one of which is:

DATETIME_PARSE(DATETIME_FORMAT(TODAY(), "YYYYMM"), "YYYYMM")

Thank you! Works just as I wished