web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to use Now() Funct...
Microsoft Dynamics CRM (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    jestuder Profile Picture
    jestuder 158 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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
    CMilton Profile Picture
    CMilton 110 on at

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



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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans