Hi,

i have a problem to submit the date to database, i have a form in (cooperate support project) when i submit the data, the date of birth is not saved (ps1.jpg),



then when i tried to save again it show me that there are to date field are not saved (ps2.jpg)



Thank you

the date field is not saving when i use the dd.mm.yyyy format

Fixed.

The problem was linked to the use of UNIX format.

The modified files are in :
- save() function of the concerned model.
- a small change in helpers/date.php

Hi admin,

thank you for your help, unfortunately the problem is still, also the other date fields are saving wrong date

Are you using unix type ?

Ok, I got it.

Fixed now.

There was also an issue in the range filter for those dates.

Thank you very much now its working .

Hi admin,

i think the date is working in Unix and Apple server but now i am trying in windows server so it doesn't work,



in this picture i just modified the "Date of Joint" by remove the Unix format, so the date doesn't change and the other date fields are not saved.

Best Regards

Are you sure ?

Unix is a format. Not really important being on Windows, Apple or Linux...
I think it is a problem on your PHP version.

Wich php are you using ?

PHP Version 5.4.7

I cannot test it for the moment because I have not access to my virtual machines for the moment (holidays abroad).

I give you a clue to test and debug that.

The last call before to save the datas is the save() function in your model.

There you can dump $data at the end and see how are your datas.
Thanks for your help. then if you find the issue, I will fix it today in Cook.

hi admin,

i didn't find the file, can you guide me please to the file?

Thank you

Pick up the name of the table you are editing (ITEM ALIAS)

You seems to be in the FRONT.


So...
site/com_xxxx/models/[item_model_alias].php

This is your model file.
Find the save() function and try the code I gave to you to have a look on the value just BEFORE to store in database.
With this, we can determine better how are formated the dates.

i found

if (parent::save($date)) {
return true;
}
return false;

but i didn't find code (below) in this file
echo('<pre>');print_r($data);echo('</pre>');
exit();

This is the code you have to write (temporaly) to see your datas.

In this way it is possible to read what is sent to the database.
(Well, it is not the last call before physical db storage, but the last one executed by you cook component. The rest is Joomla native and should work)