Results 1 to 3 of 3

Thread: Problem with custom DATE-fields when converting a lead

  1. #1
    Selageth is offline Sugar Community Member
    Join Date
    Aug 2009
    Posts
    16

    Default Problem with custom DATE-fields when converting a lead

    Good day,

    I have tried finding a solution via the search function, but without success so far.
    I'm using SugarCRM CE 5.0 and have added a custom "Date"-field to both the Leads and the Opportunities modules. When converting a lead to a new opportunity, the field shows up just fine, including the date picker. However regardless of what date I actually enter, the resulting date in the new opportunity always shows "01.01.2000".

    I already tried to backtrack the actual SQL query and check it for consistency, but I hardly know where to look for a "Debug" flag for this matter - the actual code looks fine to me and it works with all the other custom fields except this date-field.


    Has anyone ever encountered this before or maybe a solution at hand?

    Thanks in advance!

  2. #2
    Selageth is offline Sugar Community Member
    Join Date
    Aug 2009
    Posts
    16

    Default Re: Problem with custom DATE-fields when converting a lead

    I'm sorry for the bump but has no one experienced something similar? Is this truly a genuine error?

  3. #3
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Problem with custom DATE-fields when converting a lead

    As far I understand it is a know bug on Sugar, I don´t know if it was fixed in newer version.
    A good workaround would be manage the value of custom date fields through logic_hook before_save on Opportunities.
    Sugar is trying to format an already formatted field and it returns a wrong date.
    Whenever Sugar try to save this wrong date value on database it generates a default date value, as you are facing.

    Kind regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 2012-02-08, 01:16 PM
  2. Keeping Custom Lead Data When Converting Lead -> Account
    By matthewfong in forum General Discussion
    Replies: 11
    Last Post: 2010-11-23, 02:38 PM
  3. Problem with converting date to DB format
    By dasho in forum Developer Help
    Replies: 1
    Last Post: 2008-05-26, 04:43 AM
  4. converting Lead does not save the custom fields
    By sujiea in forum Developer Help
    Replies: 1
    Last Post: 2008-02-02, 06:21 AM
  5. Replies: 1
    Last Post: 2006-07-03, 02:34 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
  •