Date (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Date (Property)

In french: Date

Available only with these kinds of connection

..Date is used to:

Retrieve the date from a DateTime variable.
Modify the date in a DateTime variable.
Retrieve the date from a Date item (in "Date and Time" format).
Not available.
Modify the date in a Date item (in "Date and Time" format).
Not available.

Reminder: The Date items are used to manage:

the simple dates "Year - Month - Day" (YYYYMMDD format)
the dates and times "Year - Month - Day - Hours - Minutes - Seconds - Milliseconds" (YYYYMMDDHHMMSSLLL format)
the durations "Number of days - Number of hours - Number of minutes - Number of seconds - Number of milliseconds" (+DHHMMSSLLL format)

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store Apps mode.

New in version 18

This property is now available in Windows Store Apps mode.

Versions 20 and later

This property is now available in browser code for the DateTime variables.

New in version 20

This property is now available in browser code for the DateTime variables.

Versions 21 and later

This property is now available in Apple Watch mode.

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

New in version 21

This property is now available in Apple Watch mode.

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

This property is now available in Apple Watch mode.

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

Example

// Operations performed on a DateTime variable
StartDate is DateTime = "200112121515"
EndDate is Date = "20011209"
// Change the date
StartDate..Date = "20011225"
// Modify the Date part
StartDate..Date = EndDate

// Operations performed on a DateTime item
MyWork.StartDate = "200112121515"
MyWork.EndDate = "20011209"
// Change the date
MyWork.StartDate..Date = "20011225"
// Modify the Date part
MyWork.StartDate..Date = MyWork.EndDate

Syntax

Finding out the date in a DateTime variable Hide the details

<Result> = <DateTime>..Date

<Result>: Date

Date extracted from the DateTime variable.

<DateTime>: DateTime

Name of the DateTime variable to use.

Modifying the date in a DateTime variable Hide the details

<DateTime>: Date or DateTime

Name of the DateTime variable to use.

<New date>: Character string or date or integer

New date in the following format:
YYYYMMDD
Integer: number of days passed between January 1st 1800 and the specified date.
Replaces the date in the specified variable.

Not available in browser code and in PHP

Finding out the date in a Date item (Date and Time format) Hide the details

<Result> = <Data file>.<Item>..Date

<Result>: Date

Date extracted from the item.

<Data file>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.

<Item>: Character string (with or without quotes)

Name of item used. This name was defined in the data model editor or by the Item description type.

Not available in browser code and in PHP

Modifying the date in a Date variable (Date and Time format) Hide the details

<Data file>: Character string (with or without quotes)

Name of data file used. This name was defined in the data model editor or by the File description type.

<Item>: Character string (with or without quotes)

Name of item used. This name was defined in the data model editor or by the Item description type.

<New date>: Character string or date or integer

New date in the following format:
YYYYMMDD
Integer: number of days passed between January 1st 1800 and the specified date.
Replaces the date in the specified date.

Remarks

The Date and DateTime types are used to manage the dates from 01/01/0001 to 31/12/9999.

Related Examples:

Unit examples (WINDEV): Calculations on durations

[ + ] Calculations on dates and times with the WLanguage functions:
- Calculate the duration between two moments (dates and times)
- Calculate a sum of durations
- Calculate an average of durations