Please wait...

Date columns

Video versionA video overview of date column in wpDataTables

wpDataTable Date columns

Date columns are used to render the date values in the format that you specify on the plugin settings page. If the content in the input data source cannot be casted as a date, PHP will reset the date to “01/01/1970” and this date will be rendered.

  • Rendering rules: value is casted as a date, then formatted using the format defined in the plugin settings.
  • Sorting rules: date.
  • Applicable filter types: date range.
  • Issues to note:
    • When working with Excel files it’s the best to set the format of Date columns as plain text; since PHPExcel library that parses Excel files does not parse the Excel date format correctly and this results in wrong rendering of the dates (usually they all get reset to 01/01/1970).
    • When you’re working with MySQL please cast timestamps, and datetime columns to just dates to avoid problems.

Example

“Date” column in this table is of date type.

Build tables like this within minutes



Never miss new features!

Join 2000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

We never spam or disclose your address to anyone.