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.

Versions 15 and later

This function is now available for Android applications.

New in version 15

This function is now available for Android applications.

Versions 16 and later

This function is now available for Windows Phone applications.

New in version 16

This function is now available for Windows Phone applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

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