Not sure if it is a bug or I am constructing ...

expressions
(Jeff Drouillard) #1

Not sure if it is a bug or I am constructing this workflow expression wrong.

I want to send a work flow when an employees sick time use is equal or greater than a duration time of 120:00:00

hours, however when I place that number into the expression it shows it to be 5.00:00 hours ( uses a decimal hour not a duration type?

(Levent KULAÇOĞLU) #2

@Jeff_Drouillard 120:00:00 hour duration is 5.00:00:00 days (120/24=5)

(Jeff Drouillard) #3

Thanks.

I can’t get the workflow to fire for some reason

(Levent KULAÇOĞLU) #4

@Jeff_Drouillard how do you calculate your [Sick Used] column value? What’s your expression? Can you also try with:

HOUR([Sick Used])/24 >= 5

(Jeff Drouillard) #5

For some odd reason it began to work with my original expression.

Thank you for your help