Post

2 followers Follow
0
Avatar

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

0
Avatar

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

Roland Pumputis 0 votes
Comment actions Permalink