Functions - type conversion – Metrohm tiamo 1.3 Manual User Manual
Page 74

48
General program functions
"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, in e.g. a comparative operation it 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;06;02;10;30;25) = 2004-06-02 10:30:25 UTC +2
(depends on the
system time)
Time('CV.Testyear';'CV.Testmonth';'CV.Testday';'CV.TestHour';'CV.TestMin';'CV.T
estSec')
= date complied from the Common variables
Functions - Type conversion
NumberToText
Syntax
y = NumberToText(Number)
Returns the entered number as
Text
.
Parameter
Number
The parameter can either be entered directly as a number or as a Variable
of the type
Number
.
Examples
NumberToText(-55.3) = -55.3
NumberToText('CV.MeanTemp')
= value of the Common variable as
Text
NumberToTime
Syntax
y = NumberToTime(Number)
Returns the entered number as
Date/Time
, with the number being inter-
preted as the number of days since 30 December 1899 at 01 a.m.