...
The support for Date type date sorting support is built in including which includes multiple language support and does not require any additional server installation - this . This is the recommended type to use for date sorting.
...
If the Date column type is specified, the default date parsing recognizes a number of common date formats including those recognized by through the browser specific JavaScript implementation. However, there may be browser specific inconsistencies. The following ISO-8601 formats are recognized consistently across browsers:
...
| Token | Description | |||||
|---|---|---|---|---|---|---|
| M, MM | Month Number (1 - 12) | |||||
| MMM, MMMM | Month Name (In the current language) | |||||
| D, DD | Day of month | |||||
| DDD, DDDD | Day of year | |||||
| d, dd, ddd, dddd | Day of week
| |||||
| YY | 2 digit year (if greater than 68 will return , it returns 1900's, otherwise 2000's) | |||||
| YYYY | 4 digit year | |||||
| a, A | AM/PM | |||||
| H, HH | 24 hour time | |||||
| h, hh | 12 hour time (use in conjunction with a or A) | |||||
| m, mm | Minutes | |||||
| s, ss | Seconds | |||||
| S | Deciseconds (1/10th of a second) | |||||
| SS | Centiseconds (1/100th of a second) | |||||
| SSS | Milliseconds (1/1000th of a second) | |||||
| Z, ZZ | Timezone offset as +07:00 or +0700 | |||||
| X | Unix timestamp |
...