ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage syntax / WLanguage types
  • Declaration and initialization
  • Properties available for the dates
  • Date ranges
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
The Date type is used to easily manipulate dates. This type converts dates almost automatically (StringToDate, DateToString, IntegerToDate, DateToInteger, etc.).
This type can be used:
  • to get and manipulate HFSQL items in Date format.
  • to get and manipulate Date Edit controls.
  • in the WLanguage date management functions.
  • to perform calculations involving dates (subtraction, addition, etc.). For more details, see Operations available with the Date type.
The Date type supports null values. For more details, see Allowing nullable types.

Remarks:
  • Several properties can be used with the Date type, to retrieve only part of the date, for example.
  • For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Example
StartDate is Date = 1205
EndDate is Date = "20011231"     // 31/12/2001
TodaysDate is Date = DateSys()
Syntax
<Variable name> is Date = <Value>
OR

<Variable name> is Date
<Variable name> = <Value>
<Variable name>:
Name of the variable to declare. When several variables of the same type are declared and initialized on the same line, only the last variable is initialized.
<Value>:
Variable initialization value (See Remarks).
Remarks

Declaration and initialization

A Date variable can be initialized with a value of one of the following types:
  • Date
  • DateTime: Only the date will be taken into account.
  • String, in YYYYMMDD format (YYYY: Year, MM: Month, DD: Day)
  • Integer: The date will then correspond to the number of days between January 1, 1800 and the specified date.
By default, a Date variable is initialized with today's date (system date). To define the default value assigned to the Date, Time and DateTime variables, use DateTimeByDefault.
Note: You can also initialize a variable of type Date with the system date using Now.

Properties available for the dates

The following properties can be used with dates:
YearReturns or modifies an integer representing the year of the specified date.
DayReturns or modifies an integer representing the day of the specified date.
MonthReturns or modifies an integer representing the month of the specified date.

For more details on the possible operations on dates (addition, subtraction, comparison), see Operations available with the Date type.
StartDate is Date = "20011201"
// Adds 5 years to the date
StartDate.Year += 5
// Modifies the month
StartDate.Month = 5
// Calculates the end (30 days later)
let EndDate = StartDate
EndDate.Month++
EndDate.Day--

Date ranges

The Date type is used to manipulate dates between 01/01/0001 and 12/31/9999.
Note: WLanguage functions and WLanguage properties make accurate calculations on dates from January 1st, 1583.
Related Examples:
Management of dates Unit examples (WINDEV): Management of dates
[ + ] Using the Date type of WLanguage and the functions for handling dates.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/19/2024

Send a report | Local help