Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

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

Posted on by Microsoft Employee

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

  • Suggested answer
    CMilton Profile Picture
    CMilton 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
    Community Member Microsoft Employee 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
    jestuder 156 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans