Alhakeem1977
Registered User.
- Local time
- Today, 19:32
- Joined
- Jun 24, 2017
- Messages
- 308
Hi,
I have got a table [tblFileLog] for a Log file system to manage the physical file movement between departments that contains the [Account number], [SentDate], [ReceivedDate] and [other columns].
My aim is how to exclude Weekends (Fridays and Saturdays) from a Datediff query between [SentDate] and [ReceivedDate] to return the number of business days?
Thanks a lot in advance!
Sent from my HUAWEI NXT-L29 using Tapatalk
I have got a table [tblFileLog] for a Log file system to manage the physical file movement between departments that contains the [Account number], [SentDate], [ReceivedDate] and [other columns].
My aim is how to exclude Weekends (Fridays and Saturdays) from a Datediff query between [SentDate] and [ReceivedDate] to return the number of business days?
Thanks a lot in advance!
Sent from my HUAWEI NXT-L29 using Tapatalk