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
9 years ago
no problem

Date(Year(Today()),Month(Today()),Day([$MyDate]))




so that will always have the year of the current year and the month of the current month, but the day number will float according to the date in your date field.