Hello there, I need a little assistance please.

Can "Today()" be used in a QBE or a Report? I am trying to use it in order to find the number of years an employee or a group of employees worked. I tried using 'example elements' in a query to no avail.

Something like: "(today() - Employee's Employment date)/ 365.25"

I can copy the data to a spreadsheet and get a result, but this not what I need.

in QBE, the word today without the parens.. in reports, functions work with the parens..

Thank you very much brother Greene. However, I gave it a shot and I am back at 'square one'.

I really need some guidance on this one.

the few remaining long-time paradox developers hang out at Home - Paradox Community, not here.. that's why I keep telling everyone to post there..

I don't know if this would help any but I've had some success in by using statements like this is...

(DatePart("yyyy",Date())-DatePart("yyyy",[Birthdate]))-1

Which in this example is taking today's year and subtracting the year of the birthday...

Hope this triggers an idea for you