beautypg.com

Metrohm tiamo 1.0 Manual User Manual

Page 73

background image

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