Customer experience | Sales, Customer Insights,...

Setting a delayed status when deadline < Now() in Business Rules

(2) Share

Report

Posted on by PC-10101354-0

Hello.
I know that there is no direct way of comparing dates in Bus rules to current time, but what have others done to overcome this.

I have set up conditional rules for my dataverse table, so we can see what projects are open, completed, delayed etc. For delayed I want to have it so the column Deadline>Now(), but obvioulsy that cannot be done directly. How have others come around this??
Thanks in advance,
Paul

All responses (2)

Answers (0)

Suggested answer

Amit Katariya007 7,797 Super User 2024 Season 1 on at

Like (2)

Report

Setting a delayed status when deadline < Now() in Business Rules

Hello User,

Please check it out the Calculated fields...if it is working as expected then no need for any customisation.

Click here

Thank you,

Amit Katariya
Suggested answer

VaHiX 2,454 on at

Like (1)

Report

Setting a delayed status when deadline < Now() in Business Rules

One common approach is to use workflows or Power Automate (formerly Microsoft Flow) to handle date comparisons.

Another approach is to use JavaScript on the form to perform the date comparison when the form loads or when a field changes.

** Please don't forget to close up the thread here by Like and verify it as an answer if it is helpful **