Junior Member
Importing dates from a CSV file
I am trying to import dates from a CSV file and I am getting errors like the following:
I have tried modifying the date formats in the csv in a number of ways including YYYY-MM-DD, YYYY-MM-DD HH:MM, MM/DD/YY, and MM/DD/YY HH:MM. None of these worked."Invalid date dtring","LBL_DATE_OF_RFP (date_of_rfp_c)",9/1/09,1
What am I missing? I couldn't find anything in the forums here or in the Implementing SugarCRM book. Thanks.
Sugar Community Member
Re: Importing dates from a CSV file
Try YYYYMMDD (no dashes)
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)
______________________________________________
Junior Member
Re: Importing dates from a CSV file
Still no luck.
Do I need to include a timestamp?"Invalid date dtring","LBL_DATE_OF_RFP (date_of_rfp_c)",20090901,1
Junior Member
Re: Importing dates from a CSV file
Finally got this working. The format has to be MM/DD/YYYY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks