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()?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Convert decimal to whole in calculated field

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans