Metrohm tiamo 1.0 Manual User Manual
Page 73

Formula editor
49
Character
Meaning
Example
y
2-place date in years
03
yyyy
4-place date in years
1999
M
1- or 2-place date in months
4, 12
MM
2-place date in months
04, 12
MMM
Abbreviated name of month
Jul, Aug
MMMM
Month name
July, August
d
1- or 2-place date in days
2, 25
dd
2-place date in days
02, 25
h
1- or 2-place time in hours (1...12 AM/PM)
5, 11
hh
2-place time in hours (1...12 AM/PM)
05, 11
H
1- or 2-place time in hours (0...23)
8, 17
HH
2-place time in hours (0...23)
08, 17
m
1- or 2-place time in minutes
2, 25
mm
2-place time in minutes
02, 25
s
1- or 2-place time in seconds
3, 55
ss
2-place time in seconds
03, 55
E
Abbreviated day of week
Mo, Tu, We
EEEE
Day of week
Monday, Tuesday
D
1- , 2- or 3-place number of day in year
2, 35, 142
DD
2- or 3-place number of day in year
02, 35, 142
DDD
3-place number of day in year
002, 035, 142
F
1-place number of day in month, e.g. the 2nd Monday in May
2
w
1- or 2-place number of week in year
5, 25
ww
2-place number of week in year
05, 25
W
1-place number of week in month
3
a
Format AM/PM
AM, PM
'
Introductory and terminating characters for entering any text
''
Enters '
'
Note
If you enter the time in the format
AM/PM then in addition to the formatting cha-
racter
h you must us the AM/PM marking a.
Examples
TimeToText(Time())
= current date and current time (system) as
Text
TimeToText(Time(2004;05;04)) = 2004-05-04 00:00:00 UTC+2
(depends on the system time)
TimeToText('CV.TestTime')
=
value of the Common variable (type Time) as
Text
TimeToText(Time(2000;12;31);"EEEE', 'dd'.'MMMM' 'yyyy") =
Sunday, 31 December 2000
TimeToText(Time(1997;05;22);"M'/'d'/'yyyy', 'h'PM'") = 5/22/1997, 12PM