Title: Date format
Last modified: January 23, 2026

---

# Date format

 *  Resolved [tmcmahon](https://wordpress.org/support/users/tmcmahon/)
 * (@tmcmahon)
 * [4 months, 2 weeks ago](https://wordpress.org/support/topic/date-format-258/)
 * If you have a date like mm-yyyy it refuses to display correctly. So I created
   seperate columns for month and year. If you have a 4 digit date yyyy and you 
   choose Date and year (y) it returns a year like 1/1/2025 instead of just 2025.
   The only way I could get it to work was choose integer and turn off commas. Then
   make the month a string.

Viewing 1 replies (of 1 total)

 *  Plugin Support [Milos Jovanovic](https://wordpress.org/support/users/milosjovanovicwpdt/)
 * (@milosjovanovicwpdt)
 * [4 months, 1 week ago](https://wordpress.org/support/topic/date-format-258/#post-18798771)
 * Hello,
 * Thank you for the detailed explanation — that helps a lot.
 * We weren’t able to reproduce the behavior as described. What you’re seeing usually
   comes down to **date format mismatches** between the source data and wpDataTables
   settings. This is a fairly common scenario, especially when working with partial
   dates (month/year or year-only). 1. Month / Year format (mm/yyyy)
 * If your source data comes from a CSV or Excel file and uses a format like `01/
   2025`, please make sure that:
    - In **wpDataTables → Settings → Date format**, the format is set to **`m/Y`**(
      example shown as `07/2005`)
    - In the **table column settings** for that date column, the **same date format(`
      m/Y`)** is selected
 * Both the global plugin setting and the individual column setting must match the
   source format exactly. Otherwise, the plugin may misinterpret the value.
 * When it comes to the second format – year-only values (yyyy), if your source 
   contains a value like `2025` and the column type is set to **Date → Year (Y)**,
   but it renders as `1/1/2025`, this again points to a format mismatch.
   Let me 
   know if you see any further issues after these checks.
 * Kind regards,
   Milos
    -  This reply was modified 4 months, 1 week ago by [Milos Jovanovic](https://wordpress.org/support/users/milosjovanovicwpdt/).

Viewing 1 replies (of 1 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdate-format-258%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Milos Jovanovic](https://wordpress.org/support/users/milosjovanovicwpdt/)
 * Last activity: [4 months, 1 week ago](https://wordpress.org/support/topic/date-format-258/#post-18798771)
 * Status: resolved