Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 11, 2022 11:23 AM
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?
Jan 11, 2022 04:09 PM
This formula can be written a variety of ways, one of which is:
DATETIME_PARSE(DATETIME_FORMAT(TODAY(), "YYYYMM"), "YYYYMM")
Jan 11, 2022 05:50 PM
Thank you! Works just as I wished