Invoice Dates

datamerc
datamerc
Offline
0
I have a couple questions related to dates:

1. For an invoice on the Invoice Details tab, I have set the Invoice Date to "2014-06-01" and the Due Date to "2014-06-15". However, on the Invoice Manager and on the customer view of the invoice, the date (May 31 2014) and due date (June 14 2014) are both one day earlier. Is the cause of this something I missed in the setup?

2. On the customer view of the invoices (My invoices, My payments, My quotes) - how do I change the date format sortable invoice and quote date column? For example, it currently shows "31/05/14", but I need the date formatted as "05/31/14" or "2014-05-31".

Thank you!
Responses (4)
  • Accepted Answer

    Monday, May 26 2014, 08:14 PM - #Permalink
    0
    hello,

    1. this is probably for the time settings on your Joomla installation. can you check that the timezone on joomla is set equally than in your server?

    2. the format can be changed in the language file. If I'm not mistaken, the variable is called DATE_FORMAT_PAYMENTS
    search for it in the /language/en-GB/en-GB.com_invoices.ini file

    let me know if that helps!
    The reply is currently minimized Show
  • Accepted Answer

    datamerc
    datamerc
    Offline
    Monday, May 26 2014, 09:38 PM - #Permalink
    0
    Thanks for the quick reply...

    1. I double-checked and the server is set as America/Chicago and in the Joomla Global Configuration>Server it is also set as Chicago.

    2. I did locate DATE_FORMAT_PAYMENTS="d M Y" and changed it to "M d Y", but that didn't seem to make a difference.
    The reply is currently minimized Show
  • Accepted Answer

    datamerc
    datamerc
    Offline
    Monday, May 26 2014, 10:36 PM - #Permalink
    0
    More research for #2...
    I've noticed that the 2 options in the Invoice Manager configuration for "layout for frontend users" displays the invoice date differently:
    > "Default (with payments)" - formatted as 31/05/14
    > "Simple (without payments)" - formatted as May 31 2014
    Neither view is affected by changing the language file DATE_FORMAT_PAYMENTS.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, May 26 2014, 10:43 PM - #Permalink
    0
    yes now I see that the DATE_FORMAT_PAYMENTS is only for the payments table (not invoices list). this can be changed as well with language but may be simpler to do it directly on the layout file.

    About the timezone setting, could you maybe send me FTP and joomla access at support@ joomlathat.com so I can take a look?
    and I can set the time format correclty as well.
    The reply is currently minimized Show
Your Reply