Comments
-
In beast mode Weekday() is starting w/ monday as 0
-
Also just noticed since the WEEKDAY() function has monday as 0, and we're subtracting 1 from the start time, it seems like, for example, if the start day is monday(0), and the end day is friday(4) then the function would take 7*(0-1)+4 giving us -3 as our starting position in the substring which won't work? would this make…
-
Here is what I came up with: CASE DATEDIFF(SUBTIME(`Completed_Date__c`,28800), SUBTIME(`CreatedDate`,28800)) WHEN 0 THEN ROUND((HOUR(SUBTIME(`Completed_Date__c`,28800)) + (MINUTE(SUBTIME(`Completed_Date__c`,28800))/60)) - (HOUR(SUBTIME(`CreatedDate`,28800)) + (MINUTE(SUBTIME(`CreatedDate`,28800)) / 60))) ELSE ROUND( (17 -…
-
Could I maybe do a case when time is <9 then 9, and case when time is >5 then 5, case when day is saturday or sunday then monday at 9?
-
Wow this is awesome!! So there are actually quite a few cases where the start time is outside of 9-5, due to people working after hours. If I wanted those entries to basically just become 9 on the next business day, I can think of a basic case statement that would work if it was before 9 on m-f, but if it's after 5, I'm…
