BusinessObjects Board

Difference in seconds between Current Date/Time & Previo

I want to calculate in seconds the difference between the current Date/Time and a previous Date/Time

eg. [Current Date/Time] - [Yesterday Date/Time] = xxx sec

milleg1 (BOB member since 2008-10-16)

You have to calculate it at database level.

Date1- Date2 * 86400

rohit12 :india: (BOB member since 2008-11-08)

This topic may help:

Marek Chladny :slovakia: (BOB member since 2003-11-27)