Forum Discussion

ChrisBaker2's avatar
ChrisBaker2
Qrew Member
9 months ago

Date field formula that is always the 10th of the next month of a given date.

QuickBase Support Center I've looked at the formulas for dates above but couldn't find what I needed. I need a read only formula field that will always be the 10th of the following month based on...
AhuvaBrown's avatar
AhuvaBrown
Qrew Trainee
9 months ago

This should do it:

FirstDayOfMonth(AdjustMonth([Date Field], 1)) + Days(9)

AdjustMonth([Date Field], 1) returns the date one month from the date field.

FirstDayOfMonth() returns the first day of the above month.

+ Days(9) adds 9 days to the first day of the month, returning the 10th day.

I hope that works for you.



------------------------------
Ahuva Brown
------------------------------