Hi there,
In Report Studio 10, I have two date fields that I'm comparing in order to determine the interval between - looking to display how much time elapsed between two events. One event date/time is from a "master" record; the second is from a "child" record, identified using the "minimum" function to determine the earliest created child record.
The expression is pretty basic: [ChildDateTime] - [MasterDateTime] note: child will always be after master
When I run the query to view tabular data, I get this output:
4 days 0 hours 59 minutes 24 seconds
7 hours 56 minutes
This is perfect; exactly what I want, and what needs to be displayed on report. When I place into a report, and run it natively within Report Studio, it displays as expected/desired.
However, when I save the report and run it in batch from outside RS, I get different values:
4 milliseconds
0 days
I've tried changing the data format of the column in the report layout, and a number of other ways to try and force it to preserve the original interval format. It seems as though the days/hours/minutes/seconds portion of the interval is getting lost, but I can't, for the life of me, determine why. I did try explicitly displaying hours/days/minutes/seconds in interval format in the report, but they all displayed a value of 0; only milliseconds displayed a value. I've searched this forum a lot and in general, but cannot find any similar examples.
Any ideas? Your assistance is greatly appreciated. Thank you.
Bryan