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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Master - Can I include the system date in a calculation?

Status
Not open for further replies.

SHennes

Technical User
Feb 20, 2013
5
0
0
I am trying to build a report showing the employee hire date and then in another column, have it calculate the years and months of service i.e. Hire Date = 1/20/12 Years/Months of Service = 1 year 1 month System date = 02/21/13
I want to use today's date (the system date) to subtract the hire date from to get the length of service. How can I do this? What is the calculation formula that I need to use? Thanks!
 
We will be upgrading our system in the next couple of months, in the meantime...can I do what I am trying to do? If so, how?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top