ccalworkhours not giving correct result on Friday.

12 replies
26 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.

L

laurensw425805

Participating Frequently

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

Known Participant

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.

sanchitg0002

Inspiring

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

mikes0011

Brainy

"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?

The Expression Guru

A

abduss0004Author

Known Participant

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.

Sign up

Login with SSO

Login to the community

Login with SSO