http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/29649.aspxThu, 12 Nov 2015 15:14:04 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:29649Method_Ben0http://forums.method.me/cs/forums/thread/29649.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=29649<p><span id="mce_0_start" style="overflow:hidden;">Hi Martina,</span></p> <p><span id="mce_12_start" style="overflow:hidden;">Great to hear youve been experimenting with method!&nbsp;</span>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.</p> <p>That being said, the correct format for the&nbsp;<strong>CloseDate&nbsp;</strong>field is;</p> <p><span id="mce_6_start" style="overflow:hidden;"></span><em>2015-Nov<span id="mce_5_start" style="overflow:hidden;"></span>-<span id="mce_4_start" style="overflow:hidden;"></span><span id="mce_3_start" style="overflow:hidden;"><span id="mce_5_end" style="overflow:hidden;"></span>12 10:00:00 AM<span id="mce_6_end" style="overflow:hidden;"><span id="mce_8_start" style="overflow:hidden;"></span></span></span></em></p> <p><em><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><br /></span></span></span></em><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">Thanks Martina!</span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">R<span id="mce_11_start" style="overflow:hidden;">e</span>gards,</span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">B<span id="mce_10_start" style="overflow:hidden;">e</span>n</span></span></span></p>http://forums.method.me/cs/forums/thread/29645.aspxWed, 11 Nov 2015 23:08:01 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:29645Martina Fahrner0http://forums.method.me/cs/forums/thread/29645.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=29645<p><span id="mce_0_start" style="overflow:hidden;">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!</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>So what is it?</p>