Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: DVMAX Research v2.0 and higher

...

The following options can be used in the two advanced settings to edit how the date is displayed

Y - 4 digit year
YS - 2 digit year
M - month number
D - day number
MN - month name
DN - day name
MNS - abbreviated month name
DNS - abbreviated day name

Example: D-MN-YS would display as 5-April-17

Setting Options v3.0 and higher

The following options can be used in the two advanced settings to edit how the date is displayed

// d Day of the month, 2 digits with leading zeros 01                                          01 to 31

// D A short textual representation of the day of the week                             Mon to Sun

// j Day of the month without leading zeros                                                   1 to 31

// l A full textual representation of the day of the week Sunday                                  Sunday to Saturday

// N ISO-8601 numeric representation of the day of the week 1                      1 (for Monday) through 7 (for Sunday)

// w Numeric representation of the day of the week 0                                      0 (for Sunday) to 6 (for Saturday)

// F A full textual representation of a month, such as January or March       January to December

// m Numeric representation of a month, with leading zeros                         01 to 12

// M A short textual representation of a month Jan                                              Jan to Dec

// n Numeric representation of a month, without leading zeros                     1 to 12

// Y A full numeric representation of a year, 4 digits Examples                                     Examples: 1999 or 2003

// y A two digit representation of a year                                                         Examples: 99 or 03

// a Lowercase Ante meridiem and Post meridiem am                                        am or pm

// A Uppercase Ante meridiem and Post meridiem                                       AM or PM

// g 12-hour format of an hour without leading zeros 1                                    1 to 12

// G 24-hour format of an hour without leading zeros                                   0 to 23

// h 12-hour format of an hour with leading zeros                                         01 to 12

// H 24-hour format of an hour with leading zeros 00                                        00 to 23

// i Minutes, with leading zeros                                                                     00 to 59

// s Seconds, with leading zeros 00                                                                  00 to 59

Example: j-M-y would display as 5-Apr-17