Grid, calendar and MySQL

Suite and Optimus Suite 5
#1

I have a Mysql table with DATE field (standard date format is YYYY-MM-DD).
I need to GET date into GRID and POST it using Dataprocessor.
Using GRID I can see the date booked in Mysql table (format 0000-00-00), but when I edit the date on the GRID using dhtmlxcalendar, the date posted is in DD/MM/YYYY format with rejecting post in Mysql. I think, I need to post date in 0000-00-00 format.
The html file is the following:

html, body { width: 100%; height: 100%; margin: 0px; overflow: hidden; background-color:white; }
-------------------------------------- I also tried to insert in the script the commands:

anagrafica.setDateFormat("%Y-%m-%d");
OR
anagrafica.setDateFormat("%Y-%m-%d","%Y-%m-%d");

but the grid doesn’t work anymore. (no data, no grid, only grey row).
Please can someone help me?
Thanks in advance.

#2

DD/MM/YYYY - is a default date mask in dhtmlxCalendar.
In case of using YYYY-MM-DD you need to call:
anagrafica.setDateFormat("%Y-%m-%d");
Please, make sure that you call setDateFormat() method before the init of the grid.
If issue still occurs for you - please, provide with a complete demo, where it can be reproduced.
Here is the tutorial:
docs.dhtmlx.com/doku.php?id=othe … leted_demo

#3

Thanks for your reply.
I attached the files requested. I disabled (with //) the setDateFormat function to see the working grid.
I inserted also the mysql dump file to generate the table.

#4

The setdateFormat() method requires dhtmlxGrid.js from PRO version.
Please, try to use the required version of the file.
Your demo will be deleted as it contains files from PRO version.

#5

Thanks for your reply.
Sorry, but I didn’t know I was using some PRO file… I downloaded it from this link (your submission - in forum) download/file.php?id=4397.
Anyway no way to solve the issue using the STD version?
Thanks

#6

Unfortunately the setDateFormat() method works in PRO version only.
You may try to use the default format of the date: DD/MM/YYYY