web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Adding 2 fields togeth...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested Answer

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

(0) Share

Report

Report

Posted on by Shap1

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):

PLUS

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

EQUALS

'Estimated End Date' (date field)

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

Thanks in advance.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Stuart-Brightwire 15 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Pallavi Phade 102 Super User 2026 Season 1

#2

ManoVerse 58 Super User 2026 Season 1

#3

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans