AppGini Community Forums

With the data format, I uploaded a large CSV file that has in a cell the date 12/31/2014. So of course in MySQL, it displays as 2014/12/31.

I want the date to display 12/31/14.

So in the dataFormats file, I added:
But I still get a display of 03/28/2008.

I did a quick change to test in the main section (when I highlight the database number in upper left) under "Localization Settings" and changed it to "Day, month, year" (instead of "Month, day, year) in the dropdown and saw the dates now displayed as 31/12/2014 once I generated the PHP pages.

So it seems that the "Localization Settings" overrides the dataFormats file so I can't display the date as 12/31/14?

Thanks

Hi danoshea,
try this below line of code in your php file in hooks folder before/after insert and before/after update functions.
$data['date'] = date('d-m-Y', strtotime($data['date']);

it may helps you