Dates not formatting properly

Home Forums Data Table Plugin Dates not formatting properly

This topic contains 1 reply, has 2 voices, and was last updated by Alex_support Alex_support 1 year, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #18137

    alisoniddings
    Participant

    Hi there,

    We are using your Tables plug-in as well as a pro add on. The settings for this table is as follows:

    DATE FORMAT:
    Date: MM-DD-YYYY

    However, the dates are formatting in all sorts of ways, as you can see here:

    EPCS Certified Products List

    Any help you can provide to remedy this would be very much appreciated.

    Thanks! Alison

    #18154
    Alex_support
    Alex_support
    Moderator

    Hello, @alisoniddings.

    Cells formatting can’t change your current date format to new one, which you’ll set in table settings. If you want to have one format for all cells in column, you should set Date format to thic column and then manually set date from calendar to each cell.

    Unfortunately it is not possible to convert “Feb. 23, 2017” to “MM-DD-YYYY” format, because date is stored in Data Base as text.
    Also, plugin can’t interprete exactly what is “06.07.2018” – it can be the sixth of July or the seventh of June. It depends of format, which you set in table settings.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Get plugins bundle today and save over 80%