beautypg.com

Time(date) – Metrohm tiamo 1.1 Manual User Manual

Page 77

background image

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