// Displays "3.25"
Info(DateTimeToReal("190001030600"))
MyDay is DateTime
MyDay = "190001030600"
// Displays "3.25"
Info(DateTimeToReal(MyDay))
Syntax
<Result> = DateTimeToReal(<DateTime to convert> [, <From 1904>])
<Result>: Real
- Number of days that correspond to the DateTime variable passed as parameter.
- -1 if an error occurred (invalid date and time).
<DateTime to convert>: DateTime variable or character string
Value of the date and time to convert. This parameter can correspond to: - a DateTime variable.
- a character string in one of the following formats:
- YYYYMMDDHHmmSSCCC
- YYYYMMDDHHmmSSCC
- YYYYMMDDHHmmSS
- YYYYMMDDHHmm
- YYYYMMDDHH
- YYYYMMDD
<From 1904>: Optional boolean
Calculation mode: - True if the date is calculated from 1904.
- False (default value) if the date is calculated from 1900.
Remarks
Calculation mode
The integer part of the result gives the serial number that corresponds to the date in the parameter:
- the count starts with 1 for 01/01/1900.
- the count starts with 0 for 01/01/1904 if <From 1904> is set to True.
The decimal part gives the fraction of a day that corresponds to the time in the parameter (for example, 06:00 corresponds to 0.25).
Valid dates/times
<DateTime to convert> is considered invalid:
- if the date is invalid or earlier than the starting date. The date must be between 01/01/1900 and 12/31/999 or 01/01/1904 and 12/31/999. You can check the validity of a date using DateValid.
- if the time is invalid. You can check the validity of a time using TimeValid.
Business / UI classification: Neutral code