BusinessObjects Board

Difference between dates

Please can you suggest me , How to get defference between two dates

My date format is : 4/27/2009 9:33:17 AM… start time and end time is same DATE data type .

Appreciate your help

kolla99 (BOB member since 2005-11-15)

Did you try using DaysBetween() function?

Jansi :india: (BOB member since 2008-05-12)

it is giving me in days … as i would need in time …

Basically i would like to calculate the the total time taken from the load start date and load end date

If i’m not clear , please let me know . Thanks

kolla99 (BOB member since 2005-11-15)

Okay. I got it. Marek has provided formula here.

Jansi :india: (BOB member since 2008-05-12)

Thanks Jansi,

I tried with the below formula

=DaysBetween([Load Start Time] ;[Load End Time]) * 86400 + ( ToNumber(FormatDate([Load End Time];"HH")) * 3600 + ToNumber(Left(FormatDate([Load End Time] ;"mm:ss") ;2)) * 60 + ToNumber(FormatDate([Load End Time] ;"ss"))) - (ToNumber(FormatDate([Load Start Time];"HH")) * 3600 + ToNumber(Left(FormatDate([Load Start Time] ;"mm:ss") ;2)) * 60 + ToNumber(FormatDate([Load Start Time] ;"ss")))

I got the out put some thing difference for the dates between load start time and load end time is 2769

2009-04-28 10:52:37 PM - 2009-04-28 11:38:46 PM

expecting is - 0:46:09 9 ( hh:Mm:ss)

Please suggest me

kolla99 (BOB member since 2005-11-15)

Have you applied the proper formatting? 2749 is the number of seconds in the time you are expecting.

hcadar1 :us: (BOB member since 2008-04-25)