Compare a date with Today's date

(0) Share

Report

Posted on by NASDel

Hi,

I need to compare a date with Today's date in a calculated field. However, Today() can't be used in a business rule. I need to calculate the duration field based on the below logic:

If Date To <= Today date Then Duration = Diffindays( Date From, Date To)

Else if Date To > Today date Then Duration = Diffindays( Date From, Today)

Could anybody help me, please?

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

NASDel 5 on at

Like (0)

Report

RE: Compare a date with Today's date

Thanks. I'm thinking about this solution. To do so, I need to set a recurring workflow to run every day.

Was this reply helpful? Yes No
Suggested answer

Zohaib Uddin Khan 2,822 on at

Like (0)

Report

RE: Compare a date with Today's date

Consider Today as ModifiedOn. Thanks.

Was this reply helpful? Yes No