Date format

  • Resolved tmcmahon

    (@tmcmahon)


    3 weeks, 4 days ago

    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 TMS

    (@milosjovanovicwpdt)

    3 weeks, 1 day ago

    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 3 weeks, 1 day ago by Milos TMS.
Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.