Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Importing Dates programmatically RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have an application which imports data into our CRM deployment from a series of CSV files extracted from an other SQL database.  This has worked fine until I added a new csv file that includes a date in the import string.  When I try importing programmatically that import fails, but if I use the import wizard on the same file it imports ok.  If I remove the date from the csv the file imports ok programmatically, so I have clearly identified the problem.  By default the dates are formatted dd/mm/yyyy, however I have tried mm/dd/yyyy and yyyy-mm-dd:T00:00:00 as well.  The date is " delimited in my file.

    Am I missing a trick somewhere?  Any help would be appreciated.

    John

    Tuesday, June 25, 2013 2:20 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can anyone help me with this problem?  I am going bald trying to overcome it.

    John

    Thursday, June 27, 2013 10:52 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi John

    Drop the first :.

    So should be yyyy-mm-ddT00:00:00

    BTW I am bald.

    Paul Developer of Summary Plus for Dynamics CRM. http://www.clew-consulting.com/summaryplus

    Friday, June 28, 2013 1:59 PM