2 followers Follow

Comparison date fields shouldn't include time

I have a custom workflow to determine projects that went late under certain criteria.  My current rule includes $C_AuthorizedEndDate <$C_ForecastEndDate , however because of the time element of the date field, projects that are scheduled to to complete on the authorized date, but the time shows later than the 8 am from the custom date, they are showing late.  How can I either ignore the time part of the datetime filed in a formula, or set the authorized date's 'time' to 23.59 in the formula.  

Lorrie Means Answered

Please sign in to leave a comment.

1 comment


Hello Lorrie,

You can measure the time difference using DateDiff() function and trigger if it's more than a day.

I hope this helps.


Roland Pumputis 0 votes
Comment actions Permalink