Hi,
I need to calculate the time period between the last 2 runs of a report(for example, for a report scheduled on a weekly basis, you would expect to see 7 days between report runs).The package is relational.The field that has to be used is timestamp.How should I do this?
Regards,
Joker
you can use _days_between after converting your timestamp to date
Quote from: khayman on 16 Sep 2014 08:54:07 PM
you can use _days_between after converting your timestamp to date
Yeah, but the thing is how will I use the cell of the previous row?
I have to find the difference between the dates in concecutive rows.
In Brief I can say that I want to use running-difference for timestamp field as it is required for a Audit report.
I am thinking that it can be done by using epoch values. But How can I convert my timestamp field to epoch date?
Please Suggest a Suitable way to achieve the requirement.
Regards,
Joker