ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Date and time functions
  • Validity of the date
  • Date format
  • Special case: is not specified
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Converts the specified date to the specified format.
Tip: If the formatted date contains the "/" characters, it must not be displayed it in a Date edit control.
Example
MyDate is Date
MyDate = "20191225"
Res = MyDate.ToString()  // Res = "12/25/2019"
Res = MyDate.ToString("MM-DD-YYYY") // Res = "12-25-2019"
Res = MyDate.ToString("Day # DD of the month # MM, YYYY")
MyDate = DateSys()
Res = MyDate.ToString(maskDateSystem) 
// Res uses the format defined in the project
MyDate is Date
MyDate = "20031202"
// Day and month capitalization depends on the project language options
Res = MyDate.ToString("DDD DD MMM YYYY") 
// Res = "tue. 02 dec. 2003" or "Tue. 02 Dec. 2003"
Res = MyDate.ToString("DDDD DD MMMM YYYY") 
// Res = "tuesday 02 december 2003" or "Tuesday 02 December 2003"
//--------
// You can force the use of uppercase letters for days and months
Res = MyDate.ToString("Ddd DD Mmm YYYY") // Res = "Tue. 02 Dec. 2003"
Res = MyDate.ToString("Dddd DD Mmmm YYYY") // Res = "Tuesday 02 December 2003"
MyDate is Date
MyDate = "20191125"
Res = MyDate.ToString(maskDateEmail) 
// Returns "Mon, 25 Nov 2019 00:00:00 +0100"
Res = MyDate.ToString(maskDateEmail)  
// Returns "Sun, 25 Aug 2019 00:00:00 +0200"
MyDate is Date
MyDate = "20121125"
Res = MyDate.ToString(maskDateEmail) 
// Returns "Sun, 25 Nov 2012 00:00:00 +0100"
Res = MyDate.ToString(maskDateEmail)  
// Returns "Sat, 25 Aug 2012 00:00:00 +0200"
MyDate is Date
MyDate = "20190101"
// As of 01/22/2019
Res = MyDate.ToString(maskDateRelativeDuration) 
// Returns: 3 weeks ago
Res = MyDate.ToString(maskDateRelativeDuration) 
// Returns: in 10 months
Res = MyDate.ToString(maskDateRelativeDuration) 
// Returns: last week
Syntax

Converting a date to string Hide the details

<Result> = <Date>.ToString([<Format>])
<Result>: Character string
Character string in the specified format.
<Date>: Date variable
Name of the Date variable to convert.
<Format>: Optional character string
Format of the converted date. This parameter can contain a word, a sentence, ... The characters that represent the different elements of the date (YYYY, YY, MM or DD) will be automatically replaced with the value in the <Date> parameter. In this string:
  • YYYY represents a 4-digit year,
  • YY represents a 2-digit year.
  • M represents the month without a leading zero,
  • MM represents a 2-digit month,
  • MMM represents a 3-letter month (e.g., Jan). The case used depends on the language options of the project.
  • Mmm represents a 3-letter month with the first letter in uppercase (e.g., Jan)
    PHP This notation is not available.
  • mmm represents a 3-letter month with the first letter in lowercase (e.g., jan)
    PHP This notation is not available.
  • MMMM represents the month as a full name (e.g., January). The case used depends on the language options of the project.
    PHP This notation is not available.
  • mmmm represents the month as a full name with the first letter in lowercase (e.g., january)
    PHP This notation is not available.
  • D represents the day without a leading zero,
  • DD represents a 2-digit day,
  • DDD represents a 3-letter day (e.g., Mon). The case used depends on the language options of the project.
  • Ddd represents a 3-letter day with the first letter in uppercase (e.g., Mon)
    PHP This notation is not available.
  • ddd represents a 3-letter day with the first letter in lowercase (e.g., mon)
    PHP This notation is not available.
  • DDDD represents the day as a full name (e.g., Monday). The case used depends on the language options of the project.
  • Dddd represents the day as a full name with the first letter in uppercase (e.g., Monday).
    PHP This notation is not available.
  • dddd represents the day as a full name with the first letter in lowercase (e.g., monday).
    PHP This notation is not available.
  • M represents the first letter of the day (e.g., M,T,W,T,F,S,S).
    If this parameter corresponds to the constant:
    maskDateEmailThe format used corresponds to the date format of the RFC-5322 standard used to encrypt an email, an RSS feed, etc, ...
    The result is expressed in the local time zone.
    WEBDEV - Browser codeAndroidJavaPHP Not available.
    maskDateEmailUTCThe format used corresponds to the date format of the RFC-5322 standard used to encrypt an email, an RSS feed, etc, ...
    The result is expressed in universal time (UTC).
    WEBDEV - Browser codeAndroidJavaPHP Not available.
    maskDateInternetThe format used corresponds to the date format of the RFC-3339 standard used for international communications.
    The result is expressed in the local time zone.
    maskDateInternetUTCThe format used corresponds to the date format of the RFC-3339 standard used for international communications.
    The result is expressed in universal time (UTC).
    WEBDEV - Browser code Not available.
    maskDateRelativeDurationThis format expresses the time elapsed (or to elapse) between today's date and the specified date. This format is expressed in natural language. The different formulations used can be configured in the project description for the current language:
    1. On the "Project" tab, in the "Project" group, click "Description".
    2. In the "Languages" tab:
      • select the language to configure.
      • select the "Date" tab.
    3. Click the "Dates and Times in natural language" button.
    4. Define (if necessary) the custom captions to use. These captions will be used:
      • for the result of <Date type>.ToString.
      • for the controls that use the "Relative duration" display mask.
    WEBDEV - Browser code Not available.
    maskDateSystemThe format used corresponds to the format defined in the project description for the current language:
    1. On the "Project" tab, in the "Project" group, click "Description".
    2. Select the "Languages" tab then the "Date" tab.
    3. The format used corresponds to:
      • the settings of the operating system,
      • the specified parameters (with the defined days and months).

    If this parameter is not specified, the DD/MM/YYYY format is used by default.
Remarks

Validity of the date

The validity of the date passed as parameter is checked. A message is displayed if the date is invalid. You can check the validity of a date using DateValid. The date storage format allows you to store dates from 01/01/0001 to 12/31/9999.
WLanguage functions and WLanguage properties make accurate calculations on dates from January 1st, 1583.

Date format

<Date type>.ToString is used to format a date returned by IntegerToDate or DateSys. The result can be assigned to a text control, for example.
To get the date in another format, use <ANSI String type>.Right, Left, Middle, etc.

Special case: <Format> is not specified

The language options specified for dates in the project description are used if no specific format is defined.
To view the project language options:
  1. Open the project description: on the "Project" tab, in the "Project" group, click "Description".
  2. Select the "Languages" tab.
For example:
  • if the project uses the language options of Windows for the dates, the days of the week and the months will start with an Uppercase character on a computer running Windows in English.
  • if the project uses specific parameters for the dates for one or more languages (custom name of the day or month, etc.), these parameters will be taken into account for the specified language.
Component: wd290std.dll
Minimum version required
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/23/2024

Send a report | Local help