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

[SHennes]

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!

 

[dfeller]

Report Master? You really need to use Crystal Reports.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[SHennes]

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?