DateDifference (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Functions for managing dates and times

Constants for managing dates

DateTimeLocalToTimeZone

DateTimeLocalToUTC

DateTimeTimeZoneToLocal

Functions for managing dates and times

IntegerToDate

IntegerToDay

IntegerToDayInAlpha

IntegerToMonthInAlpha

Managing dates and times

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

DateDifference (Function)

In french: DateDifference

Calculates the number of days between two dates.

Example

// Calculates the number of days passed since 01/01/1998
nbDays is int
nbDays = DateDifference("19980101", Today())
// Displays the result
Info(nbDays + " days passed")

Syntax

<Result> = DateDifference(<Start date> , <End date>)

<Result>: Integer

Number of days passed between two dates. This number of days results from the operation:

<End date> - <Start date>

The number of days is negative if <Start date> is after <End date>.

<Start date>: Character string or Date variable

Start date for the calculation in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD to the day).

<End date>: Character string or Date variable

End date for the calculation in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD to the day).

Remarks

The validity of dates passed in parameter is checked. A message is displayed if the date is invalid. The validity of a date can be checked by DateValid.

This function cannot be used to calculate the number of days between dates before October 14 1582 (the switch from the Julian calendar to the Gregorian calendar will not be taken into account).

The storage format allows you to store dates from 01/01/0001 to 12/31/9999.

The calculations performed on dates by the WLanguage functions or by the WLanguage properties are accurate from January 1st 1583.

Related Examples:

Unit examples (WINDEV): Management of dates

[ + ] Using the Date type of WLanguage and the functions for handling dates.

Component : wd250std.dll