Results 1 to 4 of 4

Thread: date taken as 1970 in calls

  1. #1
    shamimwilson is offline Sugar Community Member
    Join Date
    Mar 2009
    Location
    Banglore India
    Posts
    235

    Default date taken as 1970 in calls

    Hi

    I am using 5.2.0c version.
    I imported calls,meetings and other activities.
    After the import is complete I got the start date as "01/01/1970 05:30".

    How to resolve this issues.

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: date taken as 1970 in calls

    This usually means that the date was not in the proper format when imported.

    I believe the format it expects is MM/dd/YYYY
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

  3. #3
    shamimwilson is offline Sugar Community Member
    Join Date
    Mar 2009
    Location
    Banglore India
    Posts
    235

    Default Re: date taken as 1970 in calls

    Yes that was the issue.

    Ok can you plz solve my two more issues.
    1.I am not able to find 'other email' option while importing the accounts.
    2.'date created ' changes ie it takes current date and admin as creator.

    Thank you

  4. #4
    thamima is offline Senior Member
    Join Date
    Mar 2009
    Location
    Pretoria, South Africa
    Posts
    23

    Unhappy Re: date taken as 1970 in calls

    Hi All

    I am having a similar issue with date formating except in my case the date is added using a custom module. What I'm trying to do is using 'after_save' logic hook from module 1 I conditionally (not always updated, in some cases only 1 field is updated) update 2 different date fields in module 2 with input from input from module 1.

    After this update I want to use the new values in module 2 to calculate the difference between the 2 dates and update a third field (duration). My problem is that
    • The date is saved correctly in module 2 and retrieved correctly using Select query
    • But when I work with date say "date('Y', $row['start_date'])", I get 1970 yet in the database the date is 2009-04-23


    What am I missing? Please help

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. date default value showing 1970
    By sidh211 in forum Developer Help
    Replies: 8
    Last Post: 2009-09-04, 02:22 PM
  2. Replies: 0
    Last Post: 2008-01-31, 11:21 AM
  3. Sort Calls by time and date
    By ChocolateLover in forum Help
    Replies: 0
    Last Post: 2007-02-07, 06:18 PM
  4. Calls dashlet - sort by date AND time
    By ChocolateLover in forum Help
    Replies: 0
    Last Post: 2007-02-06, 06:33 PM
  5. Replies: 1
    Last Post: 2006-10-17, 04:13 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
  •