Hello,

Thanks for notifying this. We are aware of some date issues like this one which will be fixed in the next release, which we hope to release as soon as possible!

Good morning,
Do you have any idea when this might get fixed?
Thank you.

Good morning. We're running Joomla 3.4.1, the server itself is configured for "Toronto" time zone (GMT-5) and Joomla-Server-Config is set to "Toronto" also. We see the problem at different places. Some examples: 1. In invoices list view, enter "2015-01-01" as start filter and then the "Total Invoice" block shows the amount and "From 31 Dec 2014". 2. Create a new invoive in the morning, enter a date, save it, in the invoice list it shows the day before the invoice (however, create an invoice in the evening, save and the invoice lists shows the right date). 3. When enter a payment, enter a date, save, it shows being paid the day before the date entered.

Hello, thank you for the quick response. What type of access to the site do you need? I'm not sure I like the idea... sorry. Do you need just Joomla admin or root access? Or if you tell me what needs to be changed, I'm sure I can do it. Thank you.

I'm very confortable with PHP... thank you.

great! then, here it comes:
basically what needs to be done is to pre-process all dates using the function "strtotime()" each time the function JHTML::_('date' is called.

example: in file /administrator/components/com_invoices/views/invoices/tmpl/default.php you will find this (search for it with a search function)

echo JHTML::_('date', $row->invoice_date, JText::_('DATE_FORMAT_PAYMENTS'));

in this case, you should replace it for this:

echo JHTML::_('date', strtotime($row->invoice_date), JText::_('DATE_FORMAT_PAYMENTS'));

the same way, in other places that this function appears, you should do the same (you have a few on this page, at the top for instance, you have this:

JHTML::_('date', $this->cal_start, JText::_('DATE_FORMAT_PAYMENTS'))

which is what prints the date info of the date filter, which is causing you problems as well. you should apply the same change here.

The reason for all this is that the function JHTML::_('date', which is a native joomla function, seems to work erratically since Joomla 3. We found out that the best way to avoid this issue is, usually, the fix explained above..

hope this helps...

I was sceptical at first but it seems to work. I though it would have to do with time zones but apparently it's something else. I made the change you listed above and it works. Except for one file where I didn't apply the change (if I do, it breaks...), the file is: components/com_invoices/views/invoice/tmpl/default.php. Is it normal to not apply the fix to that file?

The one file where I could not apply the change was: components/com_invoices/views/invoice/tmpl/default.php. The search had found hits on lines: 117, 118, 155, 156, 191 and 249. If I add the strtotime on those lines, then Joomla returns an error page when I try to view an invoice or save it to pdf. The error I get seems to come from lines 155 or 156 and the error message is: DateTime::__construct(): Failed to parse time string (-001-11-30T07:00:00+00:00) at position 7 (-): Double timezone specification

ok. don't apply it to that file, it should be ok without it.

I am getting the same error message when trying to view invoices. If I removed the strtotime function call and just use

$payment_duedate = JHTML::_('date',$payment->payment_duedate, JText::_($this->params->get('invoice_date_format', 'DATE_FORMAT_LC3')), false) ;
$payment_datetime = JHTML::_('date',$payment->payment_datetime, JText::_($this->params->get('invoice_date_format', 'DATE_FORMAT_LC3')), false) ;

in lines 155&156 in /components/com_invoices/views/invoice/tmpl/default.php

I still get the "DateTime::__construct(): Failed to parse time string (-001-11-30T07:52:58+00:00) at position 7 (-): Double timezone specification" error message.

The weird thing is that IM can read invoices generated from 2014, but not the recent ones…

So I removed all references to strtotime in that default.php. And for now it seems to be working as expected.

Very frustrating.

IM: 1.3.3
Joomla: 3.4.3
Server TZ: CDT
Joomla TZ: PST (2 hrs behind)