Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » correct syntax for date

correct syntax for date

Last post 11-12-2015 9:14 AM by Method_Ben. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 11-11-2015 5:08 PM

    correct syntax for date

    Reply Contact

    So I figured out how to upload data into Method. I even build my own opportunity template, but it to work I need the correct syntax for the closing date!

    So what is it?

  • 11-12-2015 9:14 AM In reply to

    Re: correct syntax for date

    Reply Contact

    Hi Martina,

    Great to hear youve been experimenting with method! The best way to find out the correct syntax with any field would always be to export the table (perhaps add a dummy record if the table is empty) and open this file up to see what Method expects.

    That being said, the correct format for the CloseDate field is;

    2015-Nov-12 10:00:00 AM


    Thanks Martina!

    Regards,

    Ben

    Ben Hargreaves
    Senior Support Specialist
    Method:CRM
    b.hargreaves@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)