Metrohm tiamo 2.1 (ProcessLab) User Manual
Page 88
2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
72
￭￭￭￭￭￭￭￭
tiamo 2.1 (ProcessLab)
Characters
Significance
Example
E
Weekday short form
Mon, Tue, Wed
EEEE
Weekday
Monday, Tuesday
D
one, two or three-digit number of the
day in the year
2, 35, 142
DD
two or three-digit number of the day
in the year
02, 35, 142
DDD
three-digit number of the day in the
year
002, 035, 142
F
one-digit number of the weekday in
the month, e.g. the 2nd Monday in
May
2
w
one or two-digit number of the week
in the year
5, 25
ww
two-digit number of the week in the
year
05, 25
W
one-digit number of the week in the
month
3
a
Format AM/PM
AM, PM
'
Inverted commas for entering any text
''
Entry of '
'
Note
If you wish to indicate the time in the format AM/PM, it is necessary in
addition to the formatting character h to use the AM/PM marking a (see
last example below).
Examples
TimeToText(Time()) = current date and current time (system) as Text
TimeToText(Time(2004;05;04)) = 2004-05-04 00:00:00 UTC+2
(dependent on the system time)
TimeToText('CV.TestZeit') = Value of the common variable (type Time)
as Text
TimeToText(Time(2000;12;31);"EEEE', 'dd'.'MMMM' 'yyyy") = Sun-
day, December 31, 2000
TimeToText(Time(1997;05;22);"M'/'d'/'yyyy', 'ha") = 5/22/1997,
12PM