Table JX is working fine but when data is pulled the date format looks just like it is from the database. Ex: 2014-05-31 21:00:00 Is there anything that can be done to get the date to format like this? Ex: May 31, 2014 9:00pm Thank you, David
Please Log in or Create an account to join the conversation.
Hi, this is because the data is from the database. =) Currently Table JX itself is not able to handle any date or numerical formatting. What you can do is to create a database view and handle the data formatting there. Here is an article describing in short how to use database views with Table JX. toolsjx.com/faq/3-how-to-create-a-databa...use-it-with-tools-jx Also take a look at date formatting functions of MYSQL: dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
Thank you
All fields with (*) are required
