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

Alignment/Formatting in Page Header...

I find that if I use a bunch of textboxes in a 'tabular' layout in the page
header (or anywhere) things dont line up quite right. I need a table in info
in the page header (not from a dataset just static text and param labels) so
I figure I'll use a table in the Page Header but it tells me that I cannot
use a 'data region' in the page header.
There has to be a way to create a 'table' like layout in the page header!
Any feedback/suggestions are greatly appreciated.Are you using the align to: top, bottom, side tools?
"Terry Mulvany" wrote:
> I find that if I use a bunch of textboxes in a 'tabular' layout in the page
> header (or anywhere) things dont line up quite right. I need a table in info
> in the page header (not from a dataset just static text and param labels) so
> I figure I'll use a table in the Page Header but it tells me that I cannot
> use a 'data region' in the page header.
> There has to be a way to create a 'table' like layout in the page header!
> Any feedback/suggestions are greatly appreciated.
>
>|||I have had similar problems in the past. I ended up using tables in the
"Body" of the Report to display static text and param value instead of
placing individual text boxes in the Page header. Make sure that you set the
property (RepeatonNewPage) for the static header in the table to repeat in
every page.
"Terry Mulvany" wrote:
> I find that if I use a bunch of textboxes in a 'tabular' layout in the page
> header (or anywhere) things dont line up quite right. I need a table in info
> in the page header (not from a dataset just static text and param labels) so
> I figure I'll use a table in the Page Header but it tells me that I cannot
> use a 'data region' in the page header.
> There has to be a way to create a 'table' like layout in the page header!
> Any feedback/suggestions are greatly appreciated.
>
>|||Yes, but this does not help. When the report runs the gaps between say 6 or
so rows of info varies and looks terrible, when I use a table (only
available in Body though) all rows have the same distance between them and
it looks very nice. MS needs to create a new 'layout' tollbox control (or
modify the existing table so it can be used as a non-data region object).
"BK9" <BK9@.discussions.microsoft.com> wrote in message
news:ACD30BAB-C2D8-4F42-8BD5-D9499CB77961@.microsoft.com...
> Are you using the align to: top, bottom, side tools?
> "Terry Mulvany" wrote:
>> I find that if I use a bunch of textboxes in a 'tabular' layout in the
>> page
>> header (or anywhere) things dont line up quite right. I need a table in
>> info
>> in the page header (not from a dataset just static text and param labels)
>> so
>> I figure I'll use a table in the Page Header but it tells me that I
>> cannot
>> use a 'data region' in the page header.
>> There has to be a way to create a 'table' like layout in the page header!
>> Any feedback/suggestions are greatly appreciated.
>>
>>|||Can't actually do this because I need to display different headers on
different pages (based on Globals!PageNumber) and just as Data Regions
(tables for instance) cannot be used in Page Header, 'Globals' cannot be
used in Body. So I am stuck!
"Taps" <Taps@.discussions.microsoft.com> wrote in message
news:B3F8D95E-9581-47A1-9B52-E79DC61D7782@.microsoft.com...
>I have had similar problems in the past. I ended up using tables in the
> "Body" of the Report to display static text and param value instead of
> placing individual text boxes in the Page header. Make sure that you set
> the
> property (RepeatonNewPage) for the static header in the table to repeat in
> every page.
> "Terry Mulvany" wrote:
>> I find that if I use a bunch of textboxes in a 'tabular' layout in the
>> page
>> header (or anywhere) things dont line up quite right. I need a table in
>> info
>> in the page header (not from a dataset just static text and param labels)
>> so
>> I figure I'll use a table in the Page Header but it tells me that I
>> cannot
>> use a 'data region' in the page header.
>> There has to be a way to create a 'table' like layout in the page header!
>> Any feedback/suggestions are greatly appreciated.
>>
>>