web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Calculated Fields
Customer Service forum

Calculated Fields

(0) ShareShare
ReportReport
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)
  • Verified answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at

    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..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans