Data Table Plugin

Dates not formatting properly

Dates not formatting properly

Tagged: data table, Data Table Plugin, date format, Date not formatting, supsystic

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

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

Author

Posts
15.06.2018 at 15:06 #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

19.06.2018 at 15:31 #18154

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.
Author

Posts

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%