The result between two timevalues taking also the is not possible

[thebigbadwolf]

Hello,

I have two datetime fields like 01/01/2013 10:00 and 02/01/2013 09:00.

Even if I created two formulas with their timevalues, when I am trying to take the result 09:00 - 10:00 I took 23 instead of -1 (seems like the result is taking the whole field)

Is it possible to have the -1 as a result? And if yes, which formula I must use?

 

[CoSpringsGuy]

using your example and assuming {yourtable.time1} as the datetime field of 01/01/2013 10:00 and {yourtable.time2} as the datetime field of 01/01/2013 9:00 the following formula will result in -1

DateDiff ("h",{yourtable.time1},{yourtable.time1})

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[thebigbadwolf]

I tried this and again the result was 23. An I think is normal as this function uses the whole date field

 

[CoSpringsGuy]

if both fields are datetime fields try this

hour({yourdb.date2})-hour({yourdb.date1})

If that doesn't work reduce the formula to hour({yourdb.date2}) and verify the output is the hour portion of your field. If its not then the field may not be a datetime field.

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection