Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to Find Day Differ...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to Find Day Difference between today's date and Date field in SSRS

(0) ShareShare
ReportReport
Posted on by H V 347

Hi All,

We are finding a day difference between today's date and a date field which is in CRM entity. But I'm getting wrong count of days.

I have also checked value of both today's date and field value:

Today's Date: 9/18/2020 12:00:00 AM

CRM field value: 18.09.2020

=IIF(IsNothing(First(Fields!new_activedate.Value, "EntityDataSet")), 0, DateDiff("d", First(Fields!new_activedate.Value, "EntityDataSet"), Today))

Our CRM Time Zone is GMT 01:00 Amsterdam, Berlin, Bern, Rome and system time zone is IST. Below is my date format in CRM which we need.

DateFormat.PNG

Please suggest us!

  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: How to Find Day Difference between today's date and Date field in SSRS

    Hi..

    Looks like today's date and activedate are in different format / timezone. First you need to convert both dates into same timezone and then take difference.

  • Pankaj Gogoi Profile Picture
    Pankaj Gogoi 3,177 on at
    RE: How to Find Day Difference between today's date and Date field in SSRS

    Hi,

    I think you have to convert the time to ToUniversalTime() and then find the difference.

    Best Regards

    PG

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans