topic Re: difference between 2 timestamps without weekends, except when enddate is in a weekend in App Development

difference between 2 timestamps without weekends, except when enddate is in a weekend

Quentinn — Sun, 16 Jan 2022 13:27:37 GMT

Hello,

The goal is to calculate the difference between two timestamp without weekends. The problem; when the enddate is in a weekend, the formula still substracts the full 2 days, instead of calculating the real duration from friday 00:00 till the endtime, and substracting the duration with that time.

See below; the leftmost column is the correct duration, the column next to that one is what I get.

A solution would be hugely appreciated!

Re: difference between 2 timestamps without weekends, except when enddate is in a weekend

rwunderlich — Sun, 16 Jan 2022 14:41:30 GMT

I think when you reference enddate in your expression, you could round off the time if it's a weekend date. Something like:

if(WeekDay(FirstValidatingDateTime) > 4, Floor(FirstValidatingDateTime), FirstValidatingDateTime)

-Rob

Re: difference between 2 timestamps without weekends, except when enddate is in a weekend

Quentinn — Sun, 16 Jan 2022 15:09:27 GMT

Many thanks, i'm on the right path now

However, it refuses to round off sundays, even if i specify the beginning weekday

Re: difference between 2 timestamps without weekends, except when enddate is in a weekend

Quentinn — Sun, 16 Jan 2022 15:20:29 GMT

i managed to solve that, weekday 0 is sunday and 6 is saturday for some reason, i'll see if i can make my calculations work with your input

Re: difference between 2 timestamps without weekends, except when enddate is in a weekend

Quentinn — Sun, 16 Jan 2022 15:24:13 GMT

I'm almost there!

Now i'm exactly one day short so it has to do with the round in my opinion, any ideas?