bruceblack
Registered User.
- Local time
- Today, 07:49
- Joined
- Jun 30, 2017
- Messages
- 119
Hi everyone!
Stuck here defining weekends en exluding them in my query.
I have 4 fields in my query:
inbounddate and outbounddate, and inboudtime and outboundtime.
I COMBINED these fields in my query:
combistart and combiend.
The formatting of these 2 fields looks like this:
5-1-2018 9:04:42
I would like to calculate how long a certain product has been waiting, before it got send. BUT, excluding saturday and sunday.
(so dont count the weekends)
But im having trouble to define what those days are.
As we are not working saturday and sunday, i also dont have data on those days, so i cant exlude them!
Im calculating the time difference like follows:
timediff: DateDiff("h";[combistart];[combiend])
Which works fine. But how to exclude the weekends?
Thank you guys so much in advance!!!!!!
Stuck here defining weekends en exluding them in my query.
I have 4 fields in my query:
inbounddate and outbounddate, and inboudtime and outboundtime.
I COMBINED these fields in my query:
combistart and combiend.
The formatting of these 2 fields looks like this:
5-1-2018 9:04:42
I would like to calculate how long a certain product has been waiting, before it got send. BUT, excluding saturday and sunday.
(so dont count the weekends)
But im having trouble to define what those days are.
As we are not working saturday and sunday, i also dont have data on those days, so i cant exlude them!
Im calculating the time difference like follows:
timediff: DateDiff("h";[combistart];[combiend])
Which works fine. But how to exclude the weekends?
Thank you guys so much in advance!!!!!!