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 has 1 reply, 2 voices, and was last updated 4 years, 7 months ago by Alex_support.

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

Author
Posts
June 15, 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:
https://drummondgroup.com/epcs-certified-products-list/
Any help you can provide to remedy this would be very much appreciated.
Thanks! Alison
June 19, 2018 at 15:31 #18154

Alex_support
Member
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.