<<

Contents

Search

>>

 

DATEDIFF

 

 

Function

 

 

Syntax:

DATEDIFF(<Date-1>,<Date-2>)

 

<Date-1>

= <NUM-EXPRESSION>

<Date-2>

= <NUM-EXPRESSION>

 

 

Meaning:

DATEDIFF returns as value the difference <Date-1> - <Date-2> in days.

 

If <Date-1> or <Date-2> is an invalid date, DATEDIFF returns the value -999999.

 

Parameter:

Date-1

Date

Date-2

Date

 

Sample:

H% = DATEDIFF(20070101,20060101) /* Value of H% is 365

 

See also:

DATEADD

NUMDATE

STRDATE$

DAYOFWEEK

DATE$

DATEG$

DATEG8$