DaysAfter

Description

Gets the number of days one date occurs after another.

Syntax

DaysAfter ( date1, date2 )

Argument

Description

date1

A date value that is the start date of the interval being measured

date2

A date value that is the end date of the interval

Returns

Long. Returns a long containing the number of days date2 occurs after date1. If date2 occurs before date1, DaysAfter returns a negative number.

Examples

Example 1

This expression returns 4:

DaysAfter(2005-12-20, 2005-12-24)

Example 2

This expression returns -4:

DaysAfter(2005-12-24, 2005-12-20)

Example 3

This expression returns 0:

DaysAfter(2005-12-24, 2005-12-24)

Example 4

This expression returns 5:

DaysAfter(2004-12-29, 2005-01-03)

See also