Counting number of days by Date

[Payal Patel]

Hi,
I have a table with employee data. I have a field that has a "start date" of employees and a field that has "current date". Is there a query I can run that can count the number of days beween the start date and current date? I need to be able to track the number of days the employee has been on board.

Thanks,
P.

 

[dcb]

You are looking for the DateDiff Function - Have a look at the help file for the syntax

 

[Payal Patel]

I know I'm late, but thank you, this worked