Determining if there is a Sat/Sun between two dates
I'm trying to determine whether a Saturday or Sunday can be found between any two datetimes. I have a table with two datetime fields and I have determined the interval between the dates but I would like to ignore Saturdays and Sundays when calculating the interval. Networkdays() isn't accurate enough, I've tried that. If my first datetime is Friday 15th Feb at 1pm and my second datetime is Monday 18th Feb at 1pm, networkdays() returns 2 whole days, when I am looking for an exact interval in days, hours, minutes.
A solution to your issue is to split up your transactions into days. Your example transaction, Friday 15th Feb at 1pm to Monday 18th Feb at 1pm, would split into rows like this: Friday 15th; 11h Saturday 16th; 24h Sunday 17th; 24h Monday 18th; 13h
The benefit is that you will have better control, but you will have to multiply your transaction amount any count transactions expressions will need to be adjusted.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes