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