Skip to main content

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

  • January 11, 2022
  • 2 replies
  • 46 views
M
Forum|alt.badge.img+5

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

Kamille_Parks11
Forum|alt.badge.img+27

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

DATETIME_PARSE(DATETIME_FORMAT(TODAY(), "YYYYMM"), "YYYYMM")
M
Justin_Barrett
M
Forum|alt.badge.img+5
  • MattWeber
  • Author
  • New Participant
  • January 12, 2022

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

Terms & ConditionsAccessibility statement