User Manual

Formula editor 49
Parameter
none
Return value
Current date and current time in the format
yyyy-mm-dd hh:mm:ss UTC ±xx
Note
UTC = Universal Time Coordinated: reference time for the different time zones
on the earth. MET (Mean European Time) equals UTC plus 1 hour, in the sum-
mer time UTC plus 2 hours.
Time(Date)
Syntax
y = Time(year; month; day)
Returns the entered numbers in the format
Date/Time.
Parameter
year
00...99 or 1000...9999
month
1...12
day
1...31
The parameter can either be entered directly as a number or as a Variable
of the type
Number. If the parameter does not correspond to the selected
type then it will be automatically converted to it (see Type conversion
"TextToNumber"). If this is not possible then "
invalid" will be returned as the
result of this operation.
Note
Only the whole number part will be used for all parameters.
A variable of the type Date/Time cannot be transferred as a parameter here.
In both the automatic and the explicit conversion of a Time into the type Num-
ber the number of days since 30 December 1899 at 01 a.m. will be counted.
Note: 30 December 1899 01 a.m. = 0.00000 days, this number is rounded to 5
decimal places; however, e.g. a comparative operation will be carried out with
the exact value!
Return value
Date/Time in the format
yyyy-mm-dd hh:mm:ss UTC ±xx
Note
UTC = Universal Time Coordinated: reference time for the different time zones
on the earth. MET (Mean European Time) equals UTC plus 1 hour, in the sum-
mer time UTC plus 2 hours.
Examples
Time(2004;02;02) = 2004-02-02 00:00:00 UTC +1 (depends on the system
time)
Time('CV.Testyear';'CV.Testmonth';'CV.Testday') = date complied from the
Common variables