Sql update null date field

That should work. I was just considering workarounds and was going to try conditioning everything to the s and making the admin enter a designated ancient date. Your solution would keep things in the realm of common sense. This was the scenario:. I assumed it would remain and only be overwritten if there was a value in the Date Picker control. IsBlank DatePickerName. SelectedDate ,DatePickerName. Update the Default Value and On change properties as below. It works well. Hope it helps you. Hey kbirstein1 and ktvision ,.

Thanks for providing your insights on how this limitation might be overcome. I had no luck with this prospective solution until I enabled that experimental feature and started a new editing session. Once the feature was initialized following the all-important reload , I was able to blank the date field.

Perhaps you knew this already - this is certainly the only way that I've encountered to clear a date field. Here is a solution that works for me. Caution: it is not a pretty solution. Step 1. Create a stored procedure: uspMakeNull. Execute stored procedure block with:. Where something is the string representation of DBNull. What is really uninteresting, because since you have a string literal, the resulting value can never be NULL.

Note that I excluded those brackets. Don't waste your time on typing them. They only serve to make the code more difficult to read. But more generally, you should never built your SQL strings by concatenating values from the client language. Let's say, you wanted to set the column to a value from a textbox. Viewed 9k times. Here is my table skeleton.

Improve this question. Use the suggested in the manuals format for datetime literals. Add a comment. Active Oldest Votes. Improve this answer. What is the datatype of the column?

Seems unlikely. Is there any thing wrong? Collectives on Stack Overflow. Learn more. Asked 8 years, 2 months ago. Active 2 years, 10 months ago. Viewed 85k times. Improve this question. Manual Manual 1, 5 5 gold badges 16 16 silver badges 20 20 bronze badges. Add a comment.