Skip to main content
A
abduss0004
June 9, 2023
Question

ccalworkhours not giving correct result on Friday.

  • June 9, 2023
  • 12 replies
  • 0 views

Hi Members,
I am trying to calculate the working hours between two different time using calworkhours function.
It is giving perfect result for all the days except on Fridays. I have check my calendar setting as well . Friday's setting is same as other working days.
I have pasted the Screenshot of Calendar and Expression along with it's result.

EscalationCalendar Image : 

I am expecting 6 hours but it's giving 2 hours and it is same for every Friday.

Please help on this ASAP.

12 replies

L
laurensw425805
June 9, 2023

Can you maybe share more details?

How does the process calender look for other (fri)days?

Can you match the screenshot testcase with the shown process calender date (mismatch now)?

A
abduss0004Author
June 9, 2023

I took Friday in my expression and Friday is selected in Process Calendar as well.
So, the days are matching . I am getting wrong result for every Friday.

S
sanchitg0002
June 9, 2023

Never noticed this, but turns out calworhours function is a real mess (or may be I'm missing something).

mikes0011
mikes0011
Brainy
June 9, 2023

"3" seems like it'd be the valid result, if not for the calendar "end time" set at 5 pm.  It makes me wonder whether it's sneaking in any of our normal unintuitive GMT conversion either before or after the results are evaluated?

A
abduss0004Author
June 9, 2023

Hey Mike ,


Can you please have a look at my screenshots at the top.
Function is showing not giving results as expected. I have shared the Expression Result's Screenshot and Process Calendar Screenshot as well.
For every Friday , it is giving me wrong result.

Terms & ConditionsAccessibility statement