You can manipulate the dateformat while using the argument “pub” and if the field “published” belongs to your “cols“-argument. The data inside the column “published” then will appear in your individual style. Different dateformats (e.g. “j. F Y” / “Y” /…..) are available.  The full list of formats you get on the website http://codex.wordpress.org/Formatting_Date_and_Time

Syntax

[jsdatatable  cat=YourCategory  cols=title,YourColumn1,published,YourColumn2  pub=Y-m-d]

[jsdatatable  cat=YourCategory  cols=title,YourColumn1,published,YourColumn2  pub=Y.m-d]

[jsdatatable  cat=YourCategory  cols=title,YourColumn1,published,YourColumn2  pub=Y]

[jsdatatable  cat=YourCategory  cols=title,YourColumn1,published,YourColumn2  pub="j. F Y"]

Notes

Note #1
Only the field “published” can be customized! This is a wordpress build-in field, whitch exist on each wordpress post by default. But you can’t format custom post fields (e.g. “Year”) in this manner. If a custom post fields belongs to your “cols“-argument, you get back your data from the database in that way, how you put it in before!

Note #2
Please use quotation marks if a space character belongs to your pub-format.

Note #3
If you modify the dateformat through the “pub“-statement, consider the ordering  (ASC/DSC). Ordering depands in most cases on the configured dateformat. To ensure a correct sequence for your column “published” the recommended pub-format “Y-m-d” is always a good choice.

Note #4
Please consider that the field “published” is not related to field “Year” !!!!! These are 2 totally different fields. The field “Year” is merely a custom post field and exists only in our demo database for this website (it contains the 4-digit year and is not a real full date). The field “published” on the other hand is a default-wordpress-build-in-field, existing in each wordpress setup worldwide. Of course it’s possible to use both fields to declare a year of manufacture of a vehicle. In our demo database we used both fileds to show examples and to declare a year of manufacture of a vehicle. Therefore now in the following examples we can play around with this and see what exactly is the difference. NOTE: however, in the demo database both fields (“published” and “Year“)  are filled up exactly with same information. We don’t know exactly the month or the day of the manufacture of a car or motorbike. Despite of this, we need a month and day to be able to fill the field “published” (it must contain a real full date). Therefore we use a placeholder and put the “30th Dec” into each record as a dummy, that shoud be a solution, but ist fictitious of cource.


PUB ⇒ Some live examples

Please click on the links below and check out the difference:

ExampleCheck this out and see the differenceNote
05jsdatatable CAT=Motorbike COLS=Manufacturer,Model,Country,published,Year PUB=”j. F Y”a bad dateformat to order the column (it only works fine due to uniform "30th Dec")
04jsdatatable CAT=Motorbike COLS=Manufacturer,Model,Country,published,Year PUB=Yboth columns (field "published" AND field "Year") appear in the same manner
03jsdatatable CAT=Motorbike COLS=Manufacturer,Model,Country,published,Year PUB=Y-m-da good dateformat to order the column
02jsdatatable CAT=Motorbike COLS=Manufacturer,Model,Country,published,Year PUB=Y/m/din this case use slashes to display the date
01jsdatatable CAT=Motorbike COLS=Manufacturer,Model,Country,published,Yeardefault = without formatting: the field "published" (default wordpress post field) AND the field "Year" (custom post field) belong to output