I am trying to calculate transit times in an access query for a large amount of shipments and need to exclude weekends. I have tried using the SQL functions:
MyDays: CntDays([StartDate],[EndDate])
and
SELECT [StartDte], [EndDte], DateDiffExclude2([StartDte], [EndDte], "17") as WkDays...