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... Convert decimal to who...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested Answer

Convert decimal to whole in calculated field

(0) Share

Report

Report

Posted on by MZB

Hello,

I created a calculated field of type date time.

the role of the field is to add years (from a field called seniority) to a field called joining date.

but the seniority field is of type decimal. The AddYears() function in the calculated field takes only a whole number.

Is there a way to convert a seniority to whole number before using it in the function ADDYEARS()?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Partner，

Yes, ADDDAYS () function must take whole number.

You need convert decimal to whole type, but it can't be achieved in calculated field directly.

You should create another whole number field to get integer from original decimal field, then you need use new created whole number field in the calculated field.

--Using power automate to convert them:

https://powerusers.microsoft.com/t5/Building-Flows/Converting-a-decimal-to-integer/td-p/1725562

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Siv Sagar 93 Super User 2025 Season 2

#2

#3

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

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