News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Convert decimal to who...

Dynamics 365 general forum

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

Categories:

Customization / Solutions / SDK and API

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... 290,532 Super User 2024 Season 2

#2

Martin Dráb 228,501 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans