Date Difference in Report Designer
Posted: Tue Oct 24, 2023 7:28 am
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.
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.