Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Adding 2 fields together (one decimal and one date field) to another date field

(0) ShareShare
ReportReport
Posted on by 25

Looking for some help adding 2 fields together into a third date field. Below are the 2 fields needed to calculate/update the third field.

 

'Actual Start Date' (date field):

pastedimage1656451012597v1.png

PLUS

 pastedimage1656451023643v2.png

'Assignment Length' (decimal field which is entered in as months. So this would read as 5 months)

EQUALS
 

'Estimated End Date' (date field)

pastedimage1656451036097v3.png

 

Not sure if this would end up just being a calculated field but wanted to know if it can be done.

 

Thanks in advance. 

  • Suggested answer
    RE: Adding 2 fields together (one decimal and one date field) to another date field

    I believe this could be done using a calculated field

    You could use something like ADDMONTHS (date field, length field) to add a whole month (e.g. 28th June + 5 months = 28th November)

    If you wanted to count a month as 28 days, you could use a calculated field to multiply 5 x 28 then add that to your original date

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans