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
Here is an formula for AGE in full integer years.  So that would be completed full service years in your use case.



var date DOB = [DOB];

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