Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

Dynamics Formula Column

Posted on by 34
Hello!
 
Hopefully someone can help me format this formula properly! I've created a new column labelled IsOverdue and I want to be able to check whether the date has passed and the activity status is open.  It seems to dislike the = part but I don't know how to resolve it!  I've tried eq, equals, = and no joy!
 
  • RM-30040732-0 Profile Picture
    RM-30040732-0 34 on at
    Dynamics Formula Column
    Hi,
     
    This didn't originally work work for me using email_email_statecode (also I do not have the option to use AI as I am not in the US) but by copying your code further down your message did work! Thanks!
  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Dynamics Formula Column
    Hi,
    Maybe you can try to use the folllowing:
    If(ThisRecord.'Due Date' < Now() && ThisRecord.'Activity Status' = email_email_statecode.Open, "Yes", "No")
     
    You can get formula suggestions From AI.
    1.Select “Get formula suggestions (Preview)” by clicking on the arrow which is the Get formula suggestions (Previews) label.
    2.Describe what you want the formula to do, and Arrow to get the suggested formula for the provided expressions.
    3.Pasted it at Type of Formula by simply clicking on and selecting fx Type of Formula.
    Test:

    I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
    Regards,
    Leah
     

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,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans