I really need some help with a report i am putting together. I need to know the employees continual service in years, months and days. It is stored on the database as just complete years but i need it to display in the reports as yy/mm/dd so that i can run reports for those with less than 6 months, those with 6 to 12 months, those with 12 - 24 months etc etc.
I have used the formal field to do this (as i would to covert a DOB in to an age) and it works except all the figures are exactly a month out. I have asked it take todays date and take away the continual service date. Today's date is correct on the system and the continual service date on the database is also correct. Why is it a month out? I can't think of any other way to get these reports but there must be a way.
Please could someone get in touch to let me know how to do this?