Results 1 to 2 of 2

Thread: Some dates off by one

  1. #1
    jasonblack is offline Junior Member
    Join Date
    Oct 2008
    Posts
    1

    Default Some dates off by one

    Alright, I'd originally thought that this problem was limited to one module but it's popping up in weird places. Some dates within sugar are showing up as 1 day behind. For example, I can schedule a call and set it for today's date. The Call saves with the correct date. However, the Call End date that's automatically computed will show yesterday's date. I'm having the same problem with an add-on module (SuperTimeSheet). Here's what I've checked so far...

    1. Web server timezone, locale and time are all correct.
    2. php date() and gmdate() return correct info
    3. sql server (a separate box) is configured for UTC time but all setting there are correct.
    4. The dates are stored correctly within the database, it's only when they're displayed or exported that the anomaly appears.
    5. date.timezone in php.ini is explicitly set to the same timezone as the server.

    Any other suggestions?

  2. #2
    hoang is offline Sugar Community Member
    Join Date
    Oct 2007
    Posts
    51

    Default Re: Some dates off by one

    Where are you physically?
    I'm in Australia and our GMT is +10. I just imported some records with datetime/date fields into MySQL tables and all the dates are added by 10 hours when displayed. e.g. 30/3/2000 00:00 in database and 30/3/2000 10:00 in edit/detail views
    Is it a bug. Anyone else has the same problem? How to disable the addition without changing the timezone?
    Last edited by hoang; 2008-11-04 at 02:08 AM.
    Many thanks
    Hoang

    Sugarcrm 5.1 RC
    XAMPP 1.6.6a

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Emails being recieved have incorrect dates
    By marketingsnap in forum Help
    Replies: 0
    Last Post: 2007-01-17, 04:56 PM
  2. 4.5 OS - searching between dates
    By wojkal in forum Developer Help
    Replies: 1
    Last Post: 2006-12-19, 12:41 AM
  3. Project Task Dates Bugs Fix
    By tkundhi in forum Developer Help
    Replies: 5
    Last Post: 2006-01-04, 10:41 PM
  4. Replies: 3
    Last Post: 2005-09-01, 06:16 AM
  5. All dates revert to 1999?
    By VividWeb in forum Help
    Replies: 4
    Last Post: 2005-08-22, 11:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •