News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

Posted on by H V

351

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.

Please suggest us!

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

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 3,177 on at

Like (0)

Report

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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans