PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Formats the specified date into 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 = "25/12/2019"
 
Res = MyDate.ToString("MM-DD-YYYY")
// Res = "12-25-2019"
 
Res = MyDate.ToString("The number of day DD of month MM of year YYYY")
 
MyDate = DateSys()
Res = MyDate.ToString(maskDateSystem)
// Res is using the format defined in the project
MyDate is Date
MyDate = "20031202"
// The case used for the days and for the months depends on the linguistic options of the project
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"
 
// The case used for the days and for the months is forced with an uppercase character
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 = "20130101"
// The date is 01/22/2013
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 into 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 specific characters representing the different elements of the date (YYYY, YY, MM or DD) will be automatically replaced by their value identified in the <Date> string. In this string, the characters:
  • YYYY represent the year on 4 digits,
  • YY represent the year on 2 digits.
  • M represents the month (no zero is displayed in front of the month number),
  • MM represent the month on 2 digits,
  • MMM represent the month in letters on 3 characters (for example: jan). The case used depends on the linguistic options of project.
  • Versions 16 and later
    Mmm represent the month in letters on 3 characters with the first letter forced in uppercase (for example: Jan)
    New in version 16
    Mmm represent the month in letters on 3 characters with the first letter forced in uppercase (for example: Jan)
    Mmm represent the month in letters on 3 characters with the first letter forced in uppercase (for example: Jan)
  • Versions 16 and later
    mmm represent the month in letters on 3 characters with the first letter forced in lowercase (for example: jan)
    New in version 16
    mmm represent the month in letters on 3 characters with the first letter forced in lowercase (for example: jan)
    mmm represent the month in letters on 3 characters with the first letter forced in lowercase (for example: jan)
  • MMMM represent the full month in letters (for example: January). The case used depends on the linguistic options of project.
Remarks

Validity of the date

The validity of the date passed in parameter is checked. A message is displayed if the date is invalid. You can check the validity of a date using DateValid. 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.

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 Right, Left, Middle, etc.

Special case: <Format> is not specified

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