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