S
Steve McKenna
I have a database that searches for documents by date of
document and date received. If the exact date is not know
I have set up a parameter query that allows the user to
search for dates between and. Both dates are set up s
medium date with a data type of Date/Time. On the
parameter query it accepts dates in any format i.e.
12/07/04 or 12 Jul 04. However on the single date query
it only accepts 12/07/04. I need both these queries to
acept dates input in any format. How do I achieve this,
many thanks in advance
Steve
document and date received. If the exact date is not know
I have set up a parameter query that allows the user to
search for dates between and. Both dates are set up s
medium date with a data type of Date/Time. On the
parameter query it accepts dates in any format i.e.
12/07/04 or 12 Jul 04. However on the single date query
it only accepts 12/07/04. I need both these queries to
acept dates input in any format. How do I achieve this,
many thanks in advance
Steve