|
|
|
|
|
|
|
|
|
|
- YYYYMMDD format
- Miscellaneous
IntegerToDate (Function) In french: EntierVersDate Converts an integer into a date in YYYYMMDD format. IntegerToDate(73773) // Returns "20011225"
IntegerToDate(73773, "Y") // Returns "2001"
IntegerToDate(73773, "M") // Returns "12"
IntegerToDate(73773, "D") // Returns "25"
// Calculate tomorrow's date
let Tomorrow = IntegerToDate(DateToInteger(DateSys()) + 1)
Syntax
<Result> = IntegerToDate(<Date> [, <Format>])
<Result>: Character string or Date variable Date in YYYYMMDD format. <Date>: Integer Number of days elapsed since January 1st 1800 + 1 (January 1st 1800 is number 1). <Format>: Optional character string Format of the date to retrieve:- Y to retrieve the year in YYYY format,
- M to retrieve the month in MM format,
- D to retrieve the day in DD format.
If this parameter is not specified, the format used by default is YYYYMMDD (YYYY corresponds to the year, MM to the month and DD to the day). Remarks To get the date in a format other than YYYYMMDD, the string must be formatted using DateToString, Right, Left, etc. The YYYYMMDD format was chosen because it allows you to check the order of dates. This would not be possible with a date in YYYYDDMM or DDMMYYYY format, for example. Business / UI classification: Neutral code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|