Microsoft Dynamics 365 | Integration, Dataverse...

How can I automatically add 5 years to a date field?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

Hope everyone is safe and sound. I am new to dynamics and wondered what would be the correct solution to make the system automatically fill in the date field (step 4 in the scenario below)

User scenario:

There are 3 fields for the user to fill in:
1. Field A - dropdown list
2. Field B - start date of item's validity
3. Field C - end date of item's validity
User selects "Yes" from a dropdown list in the field A
User is prompted to enter the start date for the items validity in the field B. For example 2021-07-02
After the user enters the start date in the field B, the system automatically fills in the end date in the field C by adding 5 years to the date entered in field B. For example - 2026-07-02

Could someone please advice if we can write business rules or add a JavaScript to fulfil step 4? Perhaps someone has solved similar challenges?

All responses (3)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I automatically add 5 years to a date field?

Hi,

You can create a Calculated field first:

For more details on creating Calculated field, you can refer to this official documentation:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields?view=op-9-1

And then you can create a Business rule to judge whether the Field A is Yes:

For more details on creating business rules, please refer to this official documentation:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-business-rules-recommendations-apply-logic-form?view=op-9-1

This is my result:

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Frank Gong
Suggested answer

Daniel Schneider 170 on at

Like (0)

Report

RE: How can I automatically add 5 years to a date field?

Hi,

here the code:

var test = test || {};

test.Customizing = {

Load: function () {

Xrm.Page.getAttribute("your-field-with-value").addOnChange(this.AddYear);

},

AddYear: function () {

var fieldBValue = Xrm.Page.getAttribute("your-field-with-value").getValue();

var fieldCValue = new Date(fieldBValue.getFullYear() + 5, fieldBValue.getMonth(), fieldBValue.getDate());

Xrm.Page.getAttribute("your-field-to-update").setValue(fieldCValue);

}

};

add it to js file. Register it on Form to OnLoad Event.

Greetz
Suggested answer

Naveen Ganeshe 3,393 User Group Leader on at

Like (0)

Report

RE: How can I automatically add 5 years to a date field?

Hello,

There are some solutions for your scenario:

1. Write a Javascript

2. Write a system workflow

3. you can make field B a calculated field and add 5 years to it. Please see the below screenshot: