website is IIS5, written in mostly FP2003 and ASP, Access 2000 d/b

client now decides he wants to search on dates and date ranges.

i had the various date-type fields as text fields, but with a
formatting of short year.

now, after changing these fields to date fields, i can insert dates
into new records ok, but only if i insert into all possible date
fields, since access doesn't like empty date fields.

1. is there some ASP code that will skip inserting or upgrading these
fields if they are empty?

or

2. if i left these fields as text fields, and created a query that
created new fields based on the original text fields, but as dates and
not text, could i then use the query fields to do the searching? would
this solve all my problems? (ok, some of my problems i'll never solve


Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

On Mon, 09 Feb 2004 19:52:40 -0800, bender <larry@netgeexdotcom>
wrote:

>website is IIS5, written in mostly FP2003 and ASP, Access 2000 d/b
>
>client now decides he wants to search on dates and date ranges.
>
>i had the various date-type fields as text fields, but with a
>formatting of short year.
>
>now, after changing these fields to date fields, i can insert dates
>into new records ok, but only if i insert into all possible date
>fields, since access doesn't like empty date fields.
>
>1. is there some ASP code that will skip inserting or upgrading these
>fields if they are empty?
>
>or
>
>2. if i left these fields as text fields, and created a query that
>created new fields based on the original text fields, but as dates and
>not text, could i then use the query fields to do the searching? would
>this solve all my problems? (ok, some of my problems i'll never solve
>
>
>Larry
>- - - - - - - - - - - - - - - - - -
>"Forget it, Jake. It's Chinatown."
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
whoops! fuggetaboutit

finally got my googling to turn up Kevin Spencer's great answer from
summer of 2002 re:

1. Require a date value in the form field, which ensures that there
will be
a value in the query.
2. Use server-side logic to build your query to insert a Null value
into the
field when the form field is empty:

Thanks!
the code you provided was very elegant and effective.

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."