XModPro

DateTime passed from Form Drop-Down list

Jeff M. Jeff M. asked Dec 29, 2015
Active Dec 30 · Viewed 2398 times
<p> Hello..</p><p> I have a drop down list for our online store orders. &nbsp;It lists the order number and it's order date in one line as the drop-down. &nbsp;It's value is sent to a template to display order since the selected order.</p><p> As the data value, I have the full SQL datetime of the order; e.g.&nbsp;"<strong><em>2015-12-28 22:45:13.963</em></strong>". &nbsp;See below.</p><p> Looking at profiler, it's sending the order date as '<strong><em>12/28/2015 10:45:13 PM</em></strong>'. <strong><em>&nbsp;@LastOrderDate=N'12/28/2015 10:45:13 PM'</em></strong></p><p> How do I get the true value sent instead of XMP modifying my data?</p><p> Thanks..</p><p>&lt;DropDownList Id="DDL_DogTagOrderList" DataSourceId="CDS_DogTagOrderList" DataTextField="DropDownValue" DataValueField="OrderDate" DataField="OrderDate" DataType="string" AppendDataBoundItems="True" &gt;</p><p> &lt;listitem value="0" selected="true"&gt;Select a Dog Tag Order - Date/Time&lt;/listitem&gt;</p><p>&lt;/DropDownList&gt;</p><p>DropDownValue &nbsp; &nbsp;&nbsp;OrderNumber &nbsp; &nbsp;OrderDate</p><p>201600542 - Dec 28 2015&nbsp;10:45PM &nbsp; &nbsp;&nbsp;201600542 &nbsp; &nbsp;&nbsp;2015-12-28 22:45:13.963</p><p>201600541 - Dec 28 2015 8:39PM &nbsp; &nbsp;&nbsp;201600541 &nbsp; &nbsp;&nbsp;2015-12-28 20:39:48.917</p><p>201600540 - Dec 28 2015 8:22PM &nbsp; &nbsp;&nbsp;201600540 &nbsp; &nbsp;&nbsp;2015-12-28 20:22:33.433</p><p>201600539 - Dec 28 2015 8:14PM &nbsp; &nbsp;&nbsp;201600539 &nbsp; &nbsp;&nbsp;2015-12-28 20:14:09.793</p><p>201600538 - Dec 28 2015 7:48PM &nbsp; &nbsp;&nbsp;201600538 &nbsp; &nbsp;&nbsp;2015-12-28 19:48:22.950</p>

1 Answer

Loading answers...