[AccessD] difference in days

pedro at plex.nl pedro at plex.nl
Fri Oct 20 13:10:14 CDT 2006


Hallo Group,

i used the following sql to calculate the difference between two dates.

SELECT Datum.Rapnaam, DateDiff("d",[DatOnt],[DatScr]) AS verschil
FROM Datum;

but i forgot that i only need the difference in workingdays, without the weekends. 

Is there a way to adjust the sql?

Pedro Janssen




More information about the AccessD mailing list