Contradictory results of DateDiff function
 

Hello,
Could anyone plz point out that what could be the probable reason for
DateDiff function to give different answers for the same set of values.
I am using the following:
DateDiff ( "s", time1, time2)
Here 'time1' is greater than 'time2'. But the DateDiff function
sometimes returns a positive value and sometimes a negative value.
Thanks in advance,
Pallavi

Contradictory results of DateDiff function
 

are you really different results for the same values?

From XL/VBA Help:

If date1 refers to a later point in time than date2, the DateDiff function
returns a negative number.



In article ,
"Pallavi Singh" wrote:

Hello,
Could anyone plz point out that what could be the probable reason for
DateDiff function to give different answers for the same set of values.
I am using the following:
DateDiff ( "s", time1, time2)
Here 'time1' is greater than 'time2'. But the DateDiff function
sometimes returns a positive value and sometimes a negative value.
Thanks in advance,
Pallavi

Contradictory results of DateDiff function
 

Hello,
Sorry for wasting your time, it was a silly mistake. The dates were
different.
Thanks
P
"JE McGimpsey" wrote in message
...
are you really different results for the same values?

From XL/VBA Help:

If date1 refers to a later point in time than date2, the DateDiff
function
returns a negative number.



In article ,
"Pallavi Singh" wrote:

Hello,
Could anyone plz point out that what could be the probable reason
for
DateDiff function to give different answers for the same set of values.
I am using the following:
DateDiff ( "s", time1, time2)
Here 'time1' is greater than 'time2'. But the DateDiff function
sometimes returns a positive value and sometimes a negative value.
Thanks in advance,
Pallavi