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.
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.
Hi Guest we just wanted to alert you to a major change in the forum. We will no longer be allowing the posting of outgoing links. Please use the attachment feature to attach media to your posts.