Allowing for blank fields in date text boxes

Several textboxes are being on a web form for date entry. and we want to allow the user to leave date fields blank (if particular date is unknown). However, when the field is left blank, the SQL Server 2000 database defaults to 1/1/1900 (datatype = datetime).
My question is as follows: How is it possible to leave a date textbox field blank, and either send 00\00\0000 or spaces to the SQL Server 2000 database datetime field?
Any advice/insight is appreciated! RobEDIT
Both Datetime and SmallDatetime allow NULLs Datetime is 8bytes while Smalldatetime is 4bytes but its resolution is limited. If you want Time Span you have to use DateTime.
when you are using NULL with Datetime you must use COUNT (*) in all you calculations because all SQL Server aggregate functions ignore NULLs except COUNT (*).
Hope this helps.|||Check outthis article

Aligning text that has been placed inside text boxes

I am new to reporting services. I am having trouble aligning my text. I put
some things in text boxes and even though I have the boxes as close together
as possible, they appear far apart. I tried overlapping the boxes but then
when they deploy it pushes the data in the second box down to the next line.
Anybody know how I can fix this? Problem is part of what I am putting in the
report needs to be bolded and part doesnt, so I cant keep my data together. I
would appreciate any help that I could get.I have fixed this problem before by putting both test boxes in side of a
rectangle. Just make sure the text boxes are not over lapping . Also make the
rectangle the over all size of both text boxes.
"KimB" wrote:
> I am new to reporting services. I am having trouble aligning my text. I put
> some things in text boxes and even though I have the boxes as close together
> as possible, they appear far apart. I tried overlapping the boxes but then
> when they deploy it pushes the data in the second box down to the next line.
> Anybody know how I can fix this? Problem is part of what I am putting in the
> report needs to be bolded and part doesnt, so I cant keep my data together. I
> would appreciate any help that I could get.|||Thank you for your help. I've tried this too, and not overlapping the text
boxes solved the problem of not pushing the data to the next line. But I
still end up with my text far apart. Instead of having something like this:
First Name: Johnny (with Firstname bolded and Johnny not) I end up with
First Name: Johnny Even with the boxes as close together as I can
get them without overlapping them, the data comes back spaced far apart.
"C.M" wrote:
> I have fixed this problem before by putting both test boxes in side of a
> rectangle. Just make sure the text boxes are not over lapping . Also make the
> rectangle the over all size of both text boxes.
>
>
>
> "KimB" wrote:
> > I am new to reporting services. I am having trouble aligning my text. I put
> > some things in text boxes and even though I have the boxes as close together
> > as possible, they appear far apart. I tried overlapping the boxes but then
> > when they deploy it pushes the data in the second box down to the next line.
> > Anybody know how I can fix this? Problem is part of what I am putting in the
> > report needs to be bolded and part doesnt, so I cant keep my data together. I
> > would appreciate any help that I could get.