change the date

hello,

i am using field date, in the database it show the correct date but when i call from joodb it changed the day. sometimes change the day and month but never the year?

I tested it and I can not confirm the bug.
At the backend we use the sql-notation for dates.

yyyy-mm-dd

If you use the calendar widget it will automatically show the right format.

thanks for the replay,
i send you some images to show the problem, in this case it adding one more day but in others change day and month



hope some help

That's strange. Joodb uses the joomla jhtml function to convert date into the current language format!

If the type of your date field is REALLY date it should work. Especially if you have the same dates.

[code type=php-brief]$field= JHTML::_('date', $field, JText::_('DATE_FORMAT_LC3'));[/code]

Try to switch the frontend language to english. Are the dates still wrong?
Try to disable cache if enabled!

If you look at your example. The output dates are always the previous day.

Most likely the timezones are not the same!

Try to set the timezone in Joomla.

thanks for the replay, in this example only change one day but in others change months and days. I change my front site english, change the joomla timezone and my php timezone send you te photo?
[img]http://www.solucioneswebmexico.com/images/timezone.jpg[/img]

hoppe some help?