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) / Upcoming date entry - ...
Microsoft Dynamics CRM (Archived)

Upcoming date entry - recent date

(0) ShareShare
ReportReport
Posted on by unicorn_tech 91

Hi.  This is my query:

We have a custom entity, IP Titles (Intellectual Property Titles). Each title (entry) has 10 - 30 due dates for filing for the lifetime of the title.  I want a seperate field, called "Upcoming Due Date" that takes the recent upcoming due date of the 0-30 fields that have data.

Is there a way to do this without code? We have some javascript code running on other entities - and in these cases the business rules don't work where javascript exists.  Since I have working business rules in the IP Titles entity, I'd rather do this without code.

Please advise.  Our working process is that our IP Manager files out the due dates of the Title's lifetime in advance,and would like a seperate field that simply let's her know the upcoming date for that title.

THank you,.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at

    Hi,

    If you are trying to populate upcoming due date i.e recent date of all other 0 to 30 due dates on the same form then you can write a simple JavasScripts to compare dates and populate the recent date in upcoming due date. sample code for date comparison  -community.dynamics.com/.../crm-2016-how-to-compare-two-dates-using-javascript

    or if you wants to compare the dates in between two different records then you have go for plugin/workflow. that should pull all the records from your query with desired sorting order then populate the top1 record date in the upcoming due date. your plugin/workflow should fire when a new records created with date value or any updates to the existing due dates.

    Hope it is clear

  • unicorn_tech Profile Picture
    unicorn_tech 91 on at

    Hi.  Thank you for replying.  The dates are all in the same form, but my fear of using javascript is that it prevents the business rules from working.   So they aren't different records, they all exist within the same record. Is there a way this can be solved?

  • Suggested answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at

    Hi Again,

    Both should work, your script will not impact Business rules. Do you have Business Rules on the same due fields? but still you can have the script on some fields and test it in different scenarios to see if there is any impact.

  • unicorn_tech Profile Picture
    unicorn_tech 91 on at

    Hi.  I do not have business rules on the same fields.  Ok, I will try this then.  Thank you!

  • Suggested answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at

    Then, there wont be any impact on your rules. all should work in parallel.

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