Calculated Fields

(0) Share

Report

Posted on by Community Member

Hi,

I am trying to use a dynamic date for a calculated field in Dynamics 365. I want to calculate the DIFFINDAYS between a field in Dynamics and December 31 of the current year, so this year it would be Dec 31 2018, next year it would be Dec 31 2019 and so on. Is that possible.

Categories:

Other

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Ben Thompson 6,350 on at

Like (0)

Report

While the DIFFINDAYS bit is straightforward, the only dates accessible within a calculated field are the date and time NOW and any other date fields stored within the record itself. Calculated fields do not seem to offer a convert string into number / date option..

Sadly I think you would need to use a plugin or other custom code to work out what 31/12/this year is so you may as well use the plugin to calculate the DIFFINDAYS and populate the field directly..

Was this reply helpful? Yes No