Results 1 to 4 of 4

Thread: Date field Decreasing everytime the record is saved by one day

  1. #1
    ashokinsugar is offline Sugar Community Member
    Join Date
    Apr 2011
    Location
    INDIA
    Posts
    198

    Default Date field Decreasing everytime the record is saved by one day

    Hi Friends,

    One strange issue, When we create a record with date field say as an example "22-04-2013" . Now each time when I edit that record , the date is decreased by One day.

    The date appears to be 21-04-2013.

    and Its keep decreasing 20-04-2013.

    Please sugest. Tried using logic hook but still its the same.

    Thanks.
    Ashok

  2. #2
    kir
    kir is offline Sugar Community Member
    Join Date
    Nov 2011
    Posts
    702

    Default Re: Date field Decreasing everytime the record is saved by one day

    make sure that format of date is set properly.
    I mean that user format is different then DB date wich is always GMT.

  3. #3
    ashokinsugar is offline Sugar Community Member
    Join Date
    Apr 2011
    Location
    INDIA
    Posts
    198

    Default Re: Date field Decreasing everytime the record is saved by one day

    Hi Kir,

    Thanks for the reply, I checked with the dates, the GMT are set correctly...

    Starange ...I even removed the field from layout and save and deployed and again I included in layout but its the same.

    Now I am thinking to create one new field and assign all the data to taht field and check.

    Any way, if you have any idea please let us know.

    Thanks

  4. #4
    ashokinsugar is offline Sugar Community Member
    Join Date
    Apr 2011
    Location
    INDIA
    Posts
    198

    Default Re: Date field Decreasing everytime the record is saved by one day

    Hi Friends,

    The above issue has been resolved . I changed the region in sugarcrm local setting from asia/pacific to chicago /... and its working.


Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2013-01-17, 05:49 AM
  2. Record not Saved
    By Sunny_mhl10 in forum General Discussion
    Replies: 0
    Last Post: 2012-08-03, 10:28 AM
  3. Quantities in the product catalog are not decreasing!
    By asylum in forum Order Management
    Replies: 7
    Last Post: 2011-06-14, 06:03 PM
  4. Custom field with 'date' datatype not saved
    By Christoph in forum Help
    Replies: 0
    Last Post: 2005-07-12, 02:53 PM
  5. How is Tracker record saved?
    By ruchida in forum Help
    Replies: 0
    Last Post: 2005-03-18, 12:14 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
  •