Page History
Datetime Intrinsic Functions - AsCustomDisplayString Method
| Panel | ||
|---|---|---|
| ||
Returns the date in a user-defined format. |
Member of of Datetime Intrinsic Functions (PRIM_LIBI.IDateTimeIntrinsics)
...
Enum Value | Description |
|---|---|
h | 12 hour clock with suppressed leading zero e.g. 9 |
hh | 12 hour clock e.g. 09 |
H | 24 hour clock with suppressed leading zero e.g. 9 |
HH | 24 hour clock e.g. 21 |
m | Minutes with suppressed leading zero e.g. 4 |
mm | Minutes e.g. 04 |
mmm | Minutes blank when 0 and strips leading separator e.g. 4:00am becomes 4am |
s | Seconds with suppressed leading zero e.g. 4 |
ss | Seconds e.g. 04 |
f | Milliseconds with suppressed leading zeros e.g. 4 |
ff | Milliseconds with suppressed leading zeros e.g. 04 |
fff | Milliseconds e.g. 004 |
u | Microseconds with suppressed leading zeros e.g. 4 |
uu | Microseconds with suppressed leading zeros e.g. 04 |
uuu | Microseconds e.g. 004 |
n | Nanoseconds with suppressed leading zeros e.g. 4 |
nn | Nanoseconds with suppressed leading zeros e.g. 04 |
nnn | Nanoseconds e.g. 004 |
t | A or P |
tt | AM or PM |
tl | a or p (lowercase) |
ttl | am or pm (lowercase) |
Example
This example would produce the output 07/08/12 05.03.09 PM
...