Time/Date Expression

Time/Date Format

0

HH:MM

33

yyyy/mm/dd HH:MM:SS

1

HH:MM AM/PM

34

yyyy/mm/dd HH:MM:SS AM/PM

2

HH:MM:SS

35

yyyy-mm-dd HH:MM

3

HH:MM:SS AM/PM

36

yyyy-mm-dd HH:MM AM/PM

4

HH-MM

37

yyyy-mm-dd HH:MM:SS

5

HH-MM-SS

38

yyyy-mm-dd HH:MM:SS AM/PM

6

Month dd (e.g. March 31)

39

Month dd HH:MM
(e.g. March 31 12:00)

7

mm/dd

40

Month dd HH:MM:SS
(e.g. March 31 12:00:00)

8

mm-dd

41

Month dd yy HH:MM

(e.g. March 31 18 12:00)

9

yyyy mm dd

42

Month dd yy HH:MM:SS

(e.g. March 31 18 12:00:00)

10

yy/mm/dd

43

Month dd yyyy HH:MM

(e.g. March 31 2018 12:00)

11

yy-mm-dd

44

Month dd yyyy HH:MM:SS

(e.g. March 31 2018 12:00:00)

12

Month dd, yyyy
(e.g. March 31, 2018)

45

yy/mm

13

yyyy/mm/dd

46

yy Month (e.g. 18 March)

14

yyyy-mm-dd

47

yyyy/mm

15

mm/dd HH:MM

48

yyyy Month (e.g. 2018 March)

16

mm/dd HH:MM AM/PM

49

yy

17

mm/dd HH:MM:SS

50

yyyy

18

mm/dd HH:MM:SS AM/PM

51

mm

19

mm-dd HH:MM

52

dd

20

mm-dd HH:MM AM/PM

53

HH

21

mm-dd HH:MM:SS

54

MM

22

mm-dd HH:MM:SS AM/PM

55

SS

23

yy/mm/dd HH:MM

56

yy

24

yy/mm/dd HH:MM AM/PM

57

yyyy

25

yy/mm/dd HH:MM:SS

58

Month (e.g. March)

26

yy/mm/dd HH:MM:SS AM/PM

59

dd

27

yy-mm-dd HH:MM

60

HH

28

yy-mm-dd HH:MM AM/PM

61

MM

29

yy-mm-dd HH:MM:SS

62

SS

30

yy-mm-dd HH:MM:SS AM/PM

63

"Sunday" ~ "Saturday"

31

yyyy/mm/dd HH:MM

64

"Sunday" ~ "Saturday"

32

yyyy/mm/dd HH:MM AM/PM

65

"SUN" ~ "SAT"

 

 

TimeStr()

TimeStr

Displays the current time in the assigned format.

Function

Operation

TimeStr (TimeFormat)

Script

StrVal$ = TimeStr (TimeFormat)

Description

Displays the current time according to the TimeFormat.

Example

Displays the current year, month and day.

TimeStr (9) = yyyy mm dd

 

 

TimeConvert()

TimeConvert

Converts the specified seconds/minutes value to another format based on the format.

Function

Operation

TimeConvert(Seconds/Minutes Value, Format)

Script

n=TimeConvert(Seconds/Minutes Value, Format)

Description

Converts the specified seconds/minutes value to another format based on the Format.

Format

Description

0

Outputs a time value in seconds in the form [MM:SS].

1

Outputs a time value in seconds in the form [HH:MM:SS].

2

Outputs a time value in seconds in the form [DD HH:MM:SS].

3

Outputs a time value in minutes in the form [HH:MM].

4

Outputs a time value in minutes in the form [DD HH:MM].

Example

Outputs 3600 seconds in the form [HH:MM:SS].

TimeConvert(3600, 1) → 1:00:00

Outputs 120 minutes in the form [HH:MM].

TimeConvert(120, 3) → 2:00

 

 

TimeToStr()

TimeToStr

Outputs the specified time value as a string in Time/Date Format.

Function

Operation

TimeToStr(Time Value, Format)

Script

n=TimeToStr(Time Value, Format)

Description

Outputs the specified Time Value as a string in Time/Date Format.

Example

Outputs the day of the week for December 4, 2012 as a string.

TimeToStr(2012/12/4, 65) → “SUN”

 

 

ReportTimeStr()

ReportTimeStr

Returns the time value for the report as string.

Function

Operation

ReportTimeStr (“Time Value”, Time Format)

Script

StrVal$ = ReportTimeStr (“Time Value”, Time Format)

Description

This function returns the time value, which will be used for the report file, according to the Time Format. If you enter the Time Value as negative number, the assigned parameter will indicate the past date. If the Time Value represents the today.

Example

E.g.) Outputs the report time value.

ReportTimeStr(0D, 9) + “ “ + ReportTimeStr(0D, 64)
= Displayed time format in the report: yyYmmMddD   DATE