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

• 0
• Question
• Updated 1 year ago
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 using AdjustMonth() and Today() but was having no such luck.
• 50 Points

Posted 3 years ago

• 0
• 72,206 Points 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.
• 50 Points
Perftect, thank you!
• 142 Points What is the \$Mydate field suppose to be? I am working on something similar - I want a today's date or current date  - I am trying to take a start date of employment  and to count how many years that person has worked from "today's date - so it will change based on Today's date
thanks
• 72,206 Points 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)
• 142 Points what is DOB?
• 142 Points what is DOB?
• 72,206 Points In my example it was a date field for the Date Of Birth.
• 142 Points So I would just use my start date instead of DOB? so
var date DOB = [DOB];
would become
var date Startdate = [startdate]
• 72,206 Points 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)
(Edited)
• 142 Points comes up with a bunch of errors when I add it to the formula. \$mydate seems to be a big problem

A variable declaration must end with a semi-colon.

var date MyDate = [Start of Employment]   Date];

Year(Today())-Year(\$MyDate DOB)
-
If(
Month(Today())<Month(\$MyDate DOB)
or

(Month(Today())=Month(\$MyDate) and Day(Today())<Day(\$MyDate)),1,0)
• 72,206 Points • 142 Points • 72,206 Points 