Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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.
Thanks all!
I believe that @Gysbert_Wassenaar solution will work as long as your start time nor end time is on a Saturday or Sunday.
Hi Jason,
Check this, could be helpful:
You have to define the holidays separately if needed.
I believe that @Gysbert_Wassenaar solution will work as long as your start time nor end time is on a Saturday or Sunday.
Thanks for the input everyone, I've marked what worked. Nice and simple, I should have thought of that logic in the first place.