Query in MS Access

Status
Not open for further replies.

AHHNPANTH

Right off the assembly line
Please tell me anybody how to create query for formula of date difference. I need it urgently to calculate to find out net service of employees in MS Access.

Regards
 

Pratul_09

Journeyman
There is a DATEDIFF ( DatePart , StartDate , EndDate ) and DATEADD ( datepart , number, date ). The query will be
SELECT DATEDIFF ( DatePart , StartDate , EndDate ) AS datenew where clause.
 
Status
Not open for further replies.
Top Bottom