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 using AdjustMonth() and Today() but was having no such luck.

13 Replies

  • RoxanneZiegler's avatar
    RoxanneZiegler
    Qrew Assistant Captain
    I am trying to create the formula - the error message is from the previous post - I tried a formula above and received an error 
    currently I am having no luck 
    What i am trying to do in an employee data base - is have a field that counts the number of years since the start date of employment
  • Please post your formula so i can correct it. 

    I don't have time to re-type it, just copy and paste the formula from the formula box into this forum.