Date Difference in Report Designer

Сonversation on different topics
Post Reply
NR2000
Posts: 1
Joined: Tue Oct 24, 2023 7:21 am

Date Difference in Report Designer

Post by NR2000 »

Hello guys

Can somebody help in getting the date difference between 2 datetime fields? I am trying to find total minutes or time between a start of a visit and the end of a visit but it is not working.

The formulas that I have used are as below:

1: {DateDiff(DateTime.Parse(Visit.StartDateTime), DateTime.Parse(Visit.EndDateTime)).TotalMinutes}.
When I check this in the designer, it says "OK" but then returns an empty text box when tested.

2: {DateDiff(DateTime.Parse(Visit.StartDateTime), DateTime.Parse(Visit.EndDateTime))}
Same issue as mentioned in (1).

3: {DateDiff(Visit.StartDateTime, Visit.EndDateTime)}
Gives the error (there is no matching overloaded method for DateDiff(String,String))

Please help with this as soon as possible as I have a deadline to provide to a client.
Lech Kulikowski
Posts: 6902
Joined: Tue Mar 20, 2018 5:34 am

Re: Date Difference in Report Designer

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Post Reply