Crystal Reports Driver Guide - Supported Trip Codes for Times (Creating a Report and Defining the Report Properties)

Supported Trip Codes for Times

Trip codes are case sensitive. When specifying a trip code, you should use the case indicated in the table below.

The format for a time trip sequence is %T<format>%, where <format> contains one or more of the trip codes listed below. The resulting time is affected by the Trip Sequence Time field on the Crystal Report Form (see Specify the Trip Sequence Time).

ClearSCADA supports these trip codes for time strings within exported reports:

Trip Sequence	Description	Example
h	The hour in the day, using a 12-hour clock. Leading zeros are excluded for single-digit hours.	3 (for 3am or 3pm)
hh	The hour in the day, using a 12-hour clock. Leading zeros are included for single-digit hours.	03 (for 3am or 3pm)
H	The hour in the day, using a 24-hour clock. Leading zeros are excluded for single-digit hours.	3 (for 3am) 15 (for 3pm)
HH	The hour in the day, using a 24-hour clock. Leading zeros are included for single-digit hours.	03 (for 3am) 15 (for 3pm)
m	The minutes past the hour. Leading zeros are excluded for single-digit minutes.	4 (for four minutes past the hour)
mm	The minutes past the hour. Leading zeros are included for single-digit minutes.	04 (for four minutes past the hour)
s	The seconds past the minute. Leading zeros are excluded for single-digit seconds.	9 (for nine seconds)
ss	The seconds past the minute. Leading zeros are included for single-digit seconds.	09 (for nine seconds)
t	A one-character string, A or P, to indicate whether the time is before or after midday.	A (to indicate that a time is before midday)
tt	A two-character string, AM or PM, to indicate whether the time is before or after midday.	AM (to indicate that a time is before midday)

Example:

The code
%THH:mm:ss%

displays a time in the form
14:25:06