Available ConverterParameter Values
As part of Configuring Grids in DPE Web Applications, the ConverterParameter key defines what format the converted results are displayed in.
ConverterParameter for MsToDuration Converter
Use this converter for fields containing Milliseconds, which should be converted to a better readable format
For example to convert from 70000 ms into 1:10 minutes the Converter key would be set to 'MsToDuration' and the ConverterParameter to 'm:ss'.
Or for an entry duration
See below for all possible options
ConverterParameter for DateToString Converter
Use this converter for Date and Date / Time fields, which should be converted to a better readable format
Example Column: Created
This parameter set will convert an entry CreateDate into a better readable format, like DD.MM.YYYY HH:mm
Common Values
Type | Token | Display variants |
|---|---|---|
Year | Y | YY (70 .. 30), YYYY (1970 .. 2030) |
Month | M | M (0 .. 12), MM (00 .. 12) |
Day (of month) | D | D (0 .. 31), DD (00 .. 31) |
Hour (24 hours) | H | H (0 .. 23), HH (00 .. 23) |
Minute | m | m (0 .. 59), mm (00..59) |
Second | s | s (0 .. 59), ss (00 .. 59) |
Millisecond | S | SSS (000 .. 999) |
Video Frame count (milliseconds / 40) | f25 | - |
Video Frame count (milliseconds / 30) | f30 | - |
Example combinations
ConverterParameter | Date displayed as: |
|---|---|
DD.MM.YYYY HH.mm | 27.10.2013 10:28 |
YY.MM.DD HH.mm | 13.10.27 10:28 |
MMM DD YY | Oct 27 13 |
All possible options
Type | Token | Output |
|---|---|---|
Month | M | 1 2 ... 11 12 |
Mo | 1st 2nd ... 11th 12th | |
MM | 01 02 ... 11 12 | |
MMM | Jan Feb ... Nov Dec | |
MMMM | January February ... November December | |
Quarter | Q | 1 2 3 4 |
Day of Month | D | 1 2 ... 30 31 |
Do | 1st 2nd ... 30th 31st | |
DD | 01 02 ... 30 31 | |
Day of Year | DDD | 1 2 ... 364 365 |
DDDo | 1st 2nd ... 364th 365th | |
DDDD | 001 002 ... 364 365 | |
Day of Week | d | 0 1 ... 5 6 |
do | 0th 1st ... 5th 6th | |
dd | Su Mo ... Fr Sa | |
ddd | Sun Mon ... Fri Sat | |
dddd | Sunday Monday ... Friday Saturday | |
Day of Week (Locale) | e | 0 1 ... 5 6 |
Day of Week (ISO) | E | 1 2 ... 6 7 |
Week of Year | w | 1 2 ... 52 53 |
wo | 1st 2nd ... 52nd 53rd | |
ww | 01 02 ... 52 53 | |
Week of Year (ISO) | W | 1 2 ... 52 53 |
Wo | 1st 2nd ... 52nd 53rd | |
WW | 01 02 ... 52 53 | |
Year | YY | 70 71 ... 29 30 |
YYYY | 1970 1971 ... 2029 2030 | |
Week Year | gg | 70 71 ... 29 30 |
gggg | 1970 1971 ... 2029 2030 | |
Week Year (ISO) | GG | 70 71 ... 29 30 |
GGGG | 1970 1971 ... 2029 2030 | |
AM/PM | A | AM PM |
a | am pm | |
Hour | H | 0 1 ... 22 23 |
HH | 00 01 ... 22 23 | |
h | 1 2 ... 11 12 | |
hh | 01 02 ... 11 12 | |
Minute | m | 0 1 ... 58 59 |
mm | 00 01 ... 58 59 | |
Second | s | 0 1 ... 58 59 |
ss | 00 01 ... 58 59 | |
Fractional Second | S | 0 1 ... 8 9 |
SS | 0 1 ... 98 99 | |
SSS | 0 1 ... 998 999 | |
Timezone | z or zz | EST CST ... MST PST |
Z | -07:00 -06:00 ... +06:00 +07:00 | |
ZZ | -0700 -0600 ... +0600 +0700 | |
Unix Timestamp | X | 1360013296 |
Video Frame count (milliseconds / 40) | f25 | 00 01 … 22 23 |
Video Frame count (milliseconds / 30) | f30 | 00 01 … 28 29 |