Date formats
Optiva supports these date and time formats.
| Format | Description | en-US Culture |
|---|---|---|
f |
Long Date, Short Time | dddd, MMMM dd, yyyy h:mm tt |
F |
Long Date, Long Time | dddd, MMMM dd, yyyy h:mm:ss: tt |
t |
Short Time | h:mm tt |
T |
Long Time | h:mm:ss tt |
d |
Short Date | M/d/yyyy |
D |
Long Date | dddd, MMMM dd, yyyy |
Y |
Month/Year | MMMM, yyyy |
M |
Month/Day | MMMM ddd |
S |
Sortable format is identical in every culture. | yyyy-MM-dd T HH:mm:ss |
SD |
Sortable Date | yyyy-MM-dd |
ST |
Sortable Time | yyyy-MM-dd HH:mm |
UD |
Unambiguous Date | dd-MMM-yyyy |
UT |
Unambiguous Time | dd-MMM-yyyy HH:mm |
Use of any other format reverts to the default value. The default value is the short date (d) format. For multi-language, you can use the S, SD, ST, UD or UT format.
Date formats can be applied to grids at the column level and parameters.
MMM segments displays the abbreviated month in the browser language. See sample chart below.
| English | Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sept. |
| French | janv. | févr. | mars | avril | mai | juin | juil. | août | sept. |
Note: Parameters do not currently support storing times with parameters, only dates. So although many of the formats show the time portion, it will reset to midnight (aka time 0:00) when you are finished editing. As such, customers should be discouraged from using formats that show the time.