Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula to calculate days between a hire date and current date

Status
Not open for further replies.

joedsmoed

Programmer
Dec 8, 2014
1
US
Here is the formula I am trying to use:
{CurrentDate - {Employee.Hire Date}} / 365 * 100}

When I run the error checker it says this field name is not known and it highlights the {CurrentDate - {Employee.Hire Date}} part of the formula.

Any idea what I am doing wrong here?
 

(CurrentDate - {Employee.Hire Date}) / 365 * 100)

Curly brackets are used only to enclose database field names, formula name, parameter fields, etc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top