Why does Condition: 2:41 - (Greater Than) - 11:59 register as true instead of false?

Status: Closed · Asked by Jeffrey Yu on · 0 views

JeffreyYu — Question ·
Task History ID: IjU3NjIwNTY5MDYzMDA0MzA1MjZiNTUzZDUxMzE1MTYxNTQzMiI_3D_pc

In my worfklow, I test whether an assignment was submitted on time (12 hours remaining or more) by using a filter statement.

However, this condition doesn't make sense to me. How would I change the filter condition so that this would register as false?

JeffreyYu — Reply ·

To be clear: I am trying to treat the column as a duration, rather than a clock time

Pabblymember11 — Reply ·

Hey @JeffreyYu

When comparing times in a 12-hour format, it's essential to consider the time of day. In this case, it might be better to use a 24-hour clock format to ensure accurate comparisons, especially if you intend to evaluate times across different periods of the day in your Filter action step.

And please split the hh time and mm time and then try establishing the condition in your Filter action step.

JeffreyYu — Reply ·

the great pabbly support strikes again!

thanks supreme for the great recommendation -- this is perfect for our needs!

Pabblymember11 — Reply ·

Thanks for the update, I hope this might help you.

Back to all forum threads · Log in to reply