DateTimeValid (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Date and time management functions

Date management constants

DateTimeLocalToTimeZone

DateTimeLocalToUTC

DateTimeTimeZoneToLocal

Functions for managing dates and times

IntegerToDate

IntegerToDay

IntegerToDayInAlpha

IntegerToMonthInAlpha

Managing dates and times

Valid dates/times

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

DateTimeValid (Function)

In french: DateHeureValide

Checks the validity of a date/time between January 01, 0001 at 0 hours 0 minutes 0 seconds 0 hundredths of a second and December 31, 9999 at 23 hours 59 minutes 59 seconds 99 hundredths of a second.

Versions 21 and later

This function is now available for PHP sites.

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

New in version 21

This function is now available for PHP sites.

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

This function is now available for PHP sites.

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

Versions 25 and later

This function is now available in browser code.

New in version 25

This function is now available in browser code.

Versions 26 and later

This function is now available for Apple Watch applications.

New in version 26

This function is now available for Apple Watch applications.

Example

Res = DateTimeValid("2001122523122222") // Res returns True
Res = DateTimeValid("200125122312") // Res returns False
Res = DateTimeValid("200123") // Res returns False
Res = DateTimeValid("1482122524") // Res returns False

Syntax

<Result> = DateTimeValid(<Date/Time>)

<Result>: Boolean

True if the date/time is valid.
False otherwise. A DateTime is considered invalid if:
"MM" is not between "01" and "12".
"DD" is not between "01" and "30", "01" and "31", "01" and "28" or "01" and "29" (according to the specified month).
The date is between October 5, 1582, and October 14, 1582, inclusive. The calendar changed on the night of October 4, 1582 to October 15, 1582 (Change to the Gregorian calendar: see the notes).
"HH" is not between "00" and "23".
"mm" is not between "00" and "59".
"SS" is not between "00" and "59".
"CC" is not between "00" and "99" (or "CCC" is not between "00" and "999").

<Date/Time>: Character string or DateTime variable

Character string in YYYYMMDDHHmmSSCC format (YYYY corresponds to the year, MM to the month, DD to the day, HH to hours, mm to minutes, SS to seconds and CC to hundredths of a second (use CCC for thousandths of a second)).

Remarks

Valid dates/times

If the date/time is before October 4, 1582, it belongs to the Julian calendar. In this case, the date/time is valid.
If the date/time is after October 15, 1582, it belongs to the Gregorian calendar. In this case, the date/time is valid.
A year is a leap year if it is divisible by 4 but is not a multiple of 100. However, if this year is multiple of 400, then it is a leap year. For the other years, DateTimeValid returns False for February 29.
Tip: To enter a date/time with the correct format, use a Date Edit control and choose or define an input mask that includes the date and time (e.g. "DD/MM/YYYY HH:mm:SS"). In this case, the validity of the date/time is automatically checked.
The date storage format allows you to store dates from 01/01/0001 to 12/31/9999.

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

Business / UI classification: Neutral code

Component: wd260std.dll