Microsoft Dynamics 365 | Integration, Dataverse...

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

(0) Share

Report

Posted on by Community Member

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?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Naveen Ganeshe 3,397 User Group Leader on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Suggested answer

Daniel Schneider 172 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No