Forum Discussion

LoriLori1's avatar
LoriLori1
Qrew Member
9 years ago

How do I create a formula field that changes a date field to the the the current month?

Current date field: Date: 10-5-2016 The formula field would then generate 12-5-2016 since the current month is December, each month the formula would update to the current month. I tried u...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
yes, 
I suppose a better generic format would be this

var date MyDate = [Start Date];

Year(Today())-Year($MyDate)
-
If(
Month(Today())<Month($MyDate)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0)