Problem with _DateDiff

[Clascov]

Sorry, just realised I made a mistake - DOH.

Wish I could delete this post - is that possible ?

Edited July 5, 2008 by Clascov

[Andreik]

_DateDiff seems to fail for the difference in days if the time is included in the

date/time strings passed AND the first date/time parameter is 'older'.

Tried the code examples below in both v3.2.10.0 and v3.2.11.9 (beta), and all work

as expected except the first where $diff = $error = 0.

Searched the posts without success and would be grateful for a clue.

$diff = _DateDiff("d","2008/07/04 14:07:14","2008/07/05 12:26:54")
MsgBox(0,"","diff = " & $diff & ", error = " & @error)

$age = _DateDiff("d","2008/07/05 12:26:54","2008/07/04 14:07:14")
MsgBox(0,"","diff = " & $diff & ", error = " & @error)

$diff = _DateDiff("d","2008/07/04","2008/07/05")
MsgBox(0,"","diff = " & $diff & ", error = " & @error)

$diff = _DateDiff("d","2008/07/05","2008/07/04")
MsgBox(0,"","diff = " & $diff & ", error = " & @error)[/code

Sorry, just realised my mistake - DOH.
[/quote]

Here:

$diff = _DateDiff("d","2008/07/05","2008/07/04")
MsgBox(0,"","diff = " & $diff & ", error = " & @error)

Start time and end time.

Can we tell us what you resolve?

Edited July 5, 2008 by Andreik

[Clascov]

Sorry to waste your time Andreik.

Should have realised that start/end datetime was less than 24 hours - so _DateDiff

returned the correct value.

[Andreik]

Sorry to waste your time Andreik.

Should have realised that start/end datetime was less than 24 hours - so _DateDiff

returned the correct value.

Thanks Clascov!