View Full Version : Counting number of days by Date


Payal Patel
01-18-2010, 01:44 PM
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
01-18-2010, 02:06 PM
You are looking for the DateDiff Function - Have a look at the help file for the syntax

Payal Patel
02-03-2010, 01:24 PM
I know I'm late, but thank you, this worked