I have added some formatting to the dataFormats.cfg file.
Specifically, I have added the 2nd line, US Currency with no decimals and it works precisely.
However, I have added line 6, which should display the date as 03/04/15.
In MySQL, the date is displayed as 2015-03-04.
The "Format this field as" in AppGini does have my added choice and has changed it a bit, to 03/04/2015, but as you can see the full year displays in the webpage.
Any ideas? Thank you.
US Currency, 2 decimals (example: $21,345.67); CONCAT('$', FORMAT(%%FIELD%%, 2))
US Currency, no decimals (example: $21,345); CONCAT('$', FORMAT(%%FIELD%%, 0))
Euro Currency (example: €21,345.67); CONCAT('€', FORMAT(%%FIELD%%, 2))
UK Currency (example: £21,345.67); CONCAT('£', FORMAT(%%FIELD%%, 2))
US Year (example: 2008); DATE_FORMAT(%%FIELD%%, '%Y')
US Short Date (example: 03/28/08); DATE_FORMAT(%%FIELD%%, '%m/%d/%y')
US Short Date/Time (example: 3/28/2008 5:42PM); DATE_FORMAT(%%FIELD%%, '%c/%e/%Y %l:%i%p')