Expand Format.
Choose the Type of format in which the data will be reported.
Type |
Does the following: |
apNumberInteger |
Displays a number as an integer. If the actual number is fractional, it will be rounded. |
apNumberFixed |
Displays a fixed real number with a specified number of decimal places. |
apNumberScientific |
Displays a number in scientific notation with a specified number of decimal places. The default is 6 if precision is not specified. |
apNumberCompact |
Defines an automatic way to use either apNumberFixed or apNumberScientific formats based on the size of the value. Precision information indicates the exponent to start displaying in scientific format. |
apNumberAbsoluteTime |
Interprets a number as the number of seconds since 00:00 GMT on January 1, 1970. |
apNumberAbsoluteTimeEx |
Interprets a date and time from the value of the 8-byte floating-point number. Days are represented by whole number increments starting with 30 December 1899 GMT. Hour values are expressed as the absolute value of the fractional part of the number starting at midnight with a value of 0. This is equivalent to the Date type in CimView scripting or Visual Basic. |
apNumberRelativeTime |
Interprets a number as an elapsed time value in seconds. |
apNumberCustom |
Uses a format string in the standard C language format notation to display a number. |
Make additional entries, when they apply, to more precisely define the selected Type.
For apNumberAbsoluteTime, select the item, Absolute Time. Specify the time format string. Choose your specific entries from the following list. The letters must be in uppercase or lowercase as shown (for example, "ss", not "SS"). Characters in the format string that are enclosed in single quotation marks will appear in the same location and unchanged in the output string.
Entry |
Displays |
d |
Day of month as digits with no leading zero for single-digit days. |
dd |
Day of month as digits with leading zero for single-digit days. |
ddd |
Day of week as a three-letter abbreviation. |
dddd |
Day of week as its full name. |
M |
Month as digits with no leading zero for single-digit months. |
MM |
Month as digits with leading zero for single-digit months. |
MMM |
Month as a three-letter abbreviation. |
MMMM |
Month as its full name. |
y |
Year as last two digits, but with no leading zero for years less than 10. |
yy |
Year as last two digits, but with leading zero for years less than 10. |
yyyy |
Year represented by full four digits. |
h |
Hours with no leading zero for single-digit hours (12-hour clock). |
hh |
Hours with leading zero for single-digit hours (12-hour clock). |
H |
Hours with no leading zero for single-digit hours (24-hour clock). |
HH |
Hours with leading zero for single-digit hours (24-hour clock). |
m |
Minutes with no leading zero for single-digit minutes. |
mm |
Minutes with leading zero for single-digit minutes. |
s |
Seconds with no leading zero for single-digit seconds. |
ss |
Seconds with leading zero for single-digit seconds. |
t |
One character time marker string, such as A or P. |
tt |
Multicharacter time marker string, such as AM or PM. |
Example
To display 01/01/1999 12:05:00 AM
Use the format string: MM/dd/yyyy hh:mm:ss tt.
For apNumberAbsoluteTimeEx, the format argument consists of one or more of the following format codes. The formatting codes are preceded by a percent sign %. Characters that do not begin with % are displayed unchanged.
Format Code |
Description |
%a |
Abbreviated weekday name |
%A |
Full weekday name |
%b |
Abbreviated month name |
%B |
Full month name |
%c |
Date and time representation appropriate for locale |
%d |
Day of month as decimal number (01 - 31) |
%H |
Hour in 24-hour format (00 - 23) |
%I |
Hour in 12-hour format (01 - 12) |
%j |
Day of year as decimal number (001 - 366) |
%m |
Month as decimal number (01 - 12) |
%M |
Minute as decimal number (00 - 59) |
%p |
Current locale's A.M./P.M. indicator for 12-hour clock |
%S |
Second as decimal number (00 - 59) |
%U |
Week of year as decimal number, with Sunday as first day of week (00 - 53) |
%w |
Weekday as decimal number (0 - 6; Sunday is 0) |
%W |
Week of year as decimal number, with Monday as first day of week (00 - 53) |
%x |
Date representation for current locale |
%X |
Time representation for current locale |
%y |
Year without century, as decimal number (00 - 99) |
%Y |
Year with century, as decimal number |
%z, %Z |
Time-zone name or abbreviation; no characters if time zone is unknown |
%% |
Percent sign |
The # flag may prefix any formatting code. In that case, the meaning of the format code is changed as follows:
Format Code |
Description |
%#a, %#A, %#b, %#B, %#p, %#X, %#z, %#Z, %#% # |
|
|
Flag is ignored. (Format code above) |
%#c |
Long date and time representation, appropriate for current locale. For example: "Tuesday, March 14, 1995, 12:41:29". |
%#x |
Long date representation, appropriate to current locale. For example: "Tuesday, March 14, 1995". |
%#d, %#H, %#I, %#j, %#m, %#M, %#S, %#U, %#w, %#W, %#y, #Y |
|
|
Remove leading zeros (if any). (Format code above) |
For apNumberCustom, select the item Custom. Use a format string in the standard C language format notation to display a number.
For apNumberScientific or apNumbercompact, select Precision if you need to change it from the default of 6.
For apNumberRelativeTime, select RelativeTime. Choose one entry :
Entry |
Displays relative time as: |
apTimeDDHHMMSS |
Day:hours:minutes:seconds |
apTimeHHMMSS |
Hours:minutes:seconds. |
apTimeHHTenths |
Hours and tenths |
apTimeMMSS |
Minutes:seconds. |
apTimeMMTenths |
Minutes and tenths |
Design XY Plot axes. |