kylebible

Comments

In beast mode Weekday() is starting w/ monday as 0

in How can I show an age between 2 time stamps in business hours? Comment by kylebible March 2016
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…

in How can I show an age between 2 time stamps in business hours? Comment by kylebible March 2016
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 -…

in How can I show an age between 2 time stamps in business hours? Comment by kylebible March 2016
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?

in How can I show an age between 2 time stamps in business hours? Comment by kylebible March 2016
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…

in How can I show an age between 2 time stamps in business hours? Comment by kylebible March 2016

kylebible Member

Comments