Estimating time between two dates

[IchBistTod]

I need to estimate the time between the current date and any other specified date in days. Is there already a function to do this that I am missing?

[somdcomputerguy]

The _DateDiff UDF will do this.

[martin]

I need to estimate the time between the current date and any other specified date in days. Is there already a function to do this that I am missing?

You are missing

Help|Contents|User Defined Functions|Date Management|_DateDiff.

Edited March 13, 2010 by martin

[GEOSoft]

http://dundats.mvps.org/help/html/libfunctions/_DateDiff.htm

[Bowmore]

_DateDiff() is your friend

#include <Date.au3>

; Calculated the number of days this centuary 
$iDays = _DateDiff( 'd',"2000/01/01 00:00:00",_NowCalc())
MsgBox( 4096, "", "number of days this centuary: " & $iDays )

[IchBistTod]

can i do it in format

YYYY-DD-MM?

[GEOSoft]

Only if you open the help file and look at StringReplace() and/or StringSplit.

Are you trying to change the string before or after _DateDiff()?

[jchd]

IMHO, only ISO dates make sense inside applications. Non-computational formats are good for display only.

[Jos]

The formats supported by the _DateXXXX udfs are listed in the helpfile in the _DateTimeSplit() UDF.

Any of these formats:

"yyyy/mm/dd[ hh:mm[:ss]]"

"yyyy/mm/dd[Thh:mm[:ss]]"

"yyyy-mm-dd[ hh:mm[:ss]]"

"yyyy-mm-dd[Thh:mm[:ss]]"

"yyyy.mm.dd[ hh:mm[:ss]]"

"yyyy.mm.dd[Thh:mm[:ss]]"

Jos

[jchd]

Jos,

That's exactly what I meant

[IchBistTod]

thanks for all your help.