Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How to use Now() Function in the Formula Conditions ?

(0) ShareShare
ReportReport
Posted on by

Hi,

I want to use some conditions such as Now() in the Dynamics CRM formulas,

for example, I want get the summary value of the items payments of the day before today in the contract.

Thanks

*This post is locked for comments

  • Suggested answer
    CMilton Profile Picture
    110 on at
    RE: How to use Now() Function in the Formula Conditions ?

    Could you not create a calculated date field that simply uses the Now() function and then use this new field in the condition?



  • Community Member Profile Picture
    on at
    RE: How to use Now() Function in the Formula Conditions ?

    Thank you very much for your help James,

    I have read the link as you suggested.  and my question is similar as that case.

    Furthermore,

    As the image2 in the "Set the condition on the opportunities" section , it set the FILTERS condition as "if Status equals "Open"",

    but I want set the FILTERS as "if PlanPaymentDay before "Now()"".

    it means that I want the filter condition is not a value or a simple filed of the entity, but a Function such as Now() or Today() etc.

    But I found we cannot use the functions, and I found that the filter condition cannot use the calculated fileds.

    would you please give me help on this case?

    Thanks and best regards.  

  • Suggested answer
    jestuder Profile Picture
    158 on at
    RE: How to use Now() Function in the Formula Conditions ?

    I am assuming you are talking about calculated fields.  If I am wrong, please provide more detail.  Here is a link to the functions supported for calculated fields:

    technet.microsoft.com/.../dn832103.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans