Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 01 Feb 2017 at 4:46am
First off you would need to do a datediff in between the two dates (in seconds) then convert it to a string to the format you want (there are formulas available out on the internet, I do not have one handy).
Joined: 04 Oct 2016
Online Status: Offline
Posts: 24
Posted: 01 Feb 2017 at 5:37am
Thank you for your reply. The timestamps are from the same field so I am not sure how to use the DateDiff to get the difference of time in the same field.
There is a time stamp for the dispatch and a time stamp for the clear. If it were different fields, I can figure it out but there is the variable and the same filed.
DateDiff ("s",{incilog.timestamp}, {incilog.timestamp}) will not work unless I add the variable of the transaction type.... dispatched and cleared. I just cannot figure out how to do it.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 01 Feb 2017 at 6:51am
Then I am assuming that they are different records and that you are grouping the report in some way. If so, then you will need to store the first (or last date) in a global (I have better luck with shared) variable at the beginning of the grouping (Group Header) and then do the calculation in the Group Footer using the value from the global (or shared variable).
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 01 Feb 2017 at 7:01am
you can also join the table to itself on the PK and only pull the row with "D" in one version and "C" in the other and use that resulting data set to get the values you need
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
