XModPro

PAssing date to stored procedure

jeffwest1 jeffwest1 posted Nov 27, 2019
Active Nov 27 · Viewed 1896 times

I have some html code

[code]

<div class="xmp-form-row">
<Label CssClass="xmp-form-label label NormalBold" For="pod_datum">
Updated Date
</Label>
<DateInput Id="pod_datum" DataField="pod_datum" Nullable="false" DateOnly="true" DataType="date" Visible="true" Value='[[DateAdd:0,d,MM/dd/yyyy]]' ReadOnly="true"></DateInput>
</div>

[/code]

This give me the current date, however when I pass this to SQL I get the following error on screen

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

So, what format do I need for the date/datetime in order for this to go through, I have tried pretty much every combination known to man.

0 Replies

Loading replies...