<div>
It's complaining because the DateTime field that you're passing to generate the report is outside of the allowed datetime sql field. Please keep in mind that by default, DateTime is not nullable and if nothing is passed in to it, then it will be automatically set to DateTime.MinValue (1/1/0001 12:00:00 AM) which is actually outside the SQL datetime field range.
</div>


<div>
Hi DeviantSeev,<br />
<br />
Thanks for responding so quickly.<br />
<br />
So are you saying the value entered into my textbox is not being passed to the parameter @reportDate in my data access layer?
</div>


<div>
Yes, it seems that reportDate is coming in as a date which is outside the range of the allowed dates for insertion. It's most likely coming in as DateTime.MinValue. Two ways to troubleshoot:<br />
<br />
Debug the application or change the field in SQL from datetime to datetime2 (which accommodates the DateTime.MinValue and see what you get)
</div>


<div>
You could use SqlDateTime.MinValue for checking.
</div>


<div>
Ok,<br />
<br />
I'm on to something! I set some breakpoints all along my layers to track the reportDate. And it showed #10/20/2010# all the way to the ...<br />
<br />
Public Shared Function ActivityReportDate(ByVal uId as string, Byval rDate as Date) as ActivityReport<br />
<br />
in my data access layer but went to nothing at my parameter..<br />
<br />
(&quot;@reportDate&quot;, a.reportDate)<br />
<br />
I changed a.reportDate to rDate and a.UserId to uId<br />
<br />
and the recorded was stored in the database and the reportId value was returned and displayed in the UI.<br />
<br />
Only problem is the reportDate is now displayed in the Ui as &nbsp;12:00:00 AM<br />
Does this mean I need to format the reportDate in the public property of the object before returning it to the UI? If so, please give example.<br />
<br />
Thanks 
</div>


<div>
It depends where you are binding the data. If you are doing this on the front, you could use the .ToString(format of how you want to view the datetime) like: &lt;%# Eval(&quot;reportDate&quot;).ToStrin<wbr />g(&quot;yyyy MM dd HH:mm&quot;)
</div>


<div>
Hi Stephanonline,<br />
<br />
I tried your suggestion and no luck.<br />
<br />
IThe reportDate is supposed to return though an instance of my object ....<br />
<br />
Public Sub NewReport()<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim currentUser As MembershipUser = Membership.GetUser(HttpCon<wbr />text.Curre<wbr />nt.User.Id<wbr />entity.Nam<wbr />e)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim currentUserId As String = currentUser.ProviderUserKe<wbr />y.ToString<wbr /><br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim StartReport As New ActivityInfo.ActivityRepor<wbr />t<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; StartReport = ReportBl.getReportId(curre<wbr />ntUserId, txtReportDate.Text)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; txtReportDate.Text = StartReport.ReportDate<br />
&nbsp; &nbsp; &nbsp; &nbsp; txtReportId.Text = StartReport.ReportId<br />
<br />
End Sub<br />
&nbsp;Thanks
</div>


<div>
My suggestion would be to format the date right before you're displaying it in the UI.<br />
<br />
txtReportDate.Text = StartReport.ReportDate<br />
<br />
can be turned into something like this:<br />
<br />
txtReportDate.Text = String.Format(&quot;{0:MM/dd/yy<wbr />}&quot;,StartRe<wbr />port.Repor<wbr />tDate);<br />
<br />
You can check out the other date formatting options here:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx</a>
</div>


<div>
Hi tried to format it as suggested and no luck<br />
<br />
So I tried ..<br />
txtReportDate.text = StartReport.ReportDate.ToS<wbr />tring(&quot;MM/<wbr />dd/yyyy&quot;)<br />
<br />
and returned 01/01/0001<br />
<br />
Ugh!!! I think I need to step away for an hour.
</div>


<div>
Just added ...<br />
<br />
Dim d as Date = cmd.Parameters(&quot;@reportDat<wbr />e&quot;).Value<br />
a.ReportDate = d<br />
<br />
This seems to work but I'm not sure if it's the correct way of doing things.<br />
<br />
I entered 10/3/2005<br />
and the value remained in the textbox instead of changeing.<br />
<br />
Since @reportDate is an input parameter does this mean I'm merely taking the value stored in the parameter and passing it back through a.ReportDate of my object?
</div>


<div>
I'm such a boob! To much coffee. <br />
<br />
I was trying to return reportDate from my SP and it's totally unneccessary.<br />
<br />
I removed <br />
txtReportDate.text = StartReprot.ReportDate<br />
<br />
Thanks Deviant
</div>


<div>
lol you're welcome. I'm glad I could help. 
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
The attached file is some code I wrote that has me stymied. I get a SqlDateTime Overflow error.<br />
<br />
The user is supposed to be able to enter a report date, save the date which will pass the current user id and the date entered through the business logic, business object to the data access layer. <br />
<br />
Then I wanted &nbsp;it to return the reportId from my stored procedure back to a textbox on my UI.<br />
<br />
All code is in the attached file including the error I sent to my log file.<br />
<br />
Thanks <a href="https://filedb.experts-exchange.com/incoming/2010/12_w49/376268/ActivityCode.pdf" target="_blank" class="file-inline" title="my code (33 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ActivityCode.pdf</a>
</div>
</div>


ActivityCode.pdf

Hi,

The attached file is some code I wrote that has me stymied. I get a SqlDateTime Overflow error.

The user is supposed to be able to enter a report date, save the date which will pass the current user id and the date entered through the business logic, business object to the data access layer. 

Then I wanted  it to return the reportId from my stored procedure back to a textbox on my UI.

All code is in the attached file including the error I sent to my log file.

Thanks 

Sqldatetime overflow error

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.