Bob and Aaran

Thank you for all your advise, very useful.

Jon

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%231YU9tFuDHA.3496@TK2MSFTNGP11.phx.gbl...
Jon wrote:
> OK so I'm using
>
> Function dbDate(dt)
> dbDate = year(dt) & "/" & left("00",2-len(month(dt))) &_
> month(dt) & "/" & left("00",2-len(day(dt))) & day(dt)
> End Function
>
> (it wouldn't work without the & "/" &)
>
> Can I be sure that in
> WHERE wishlistCloseDate >= #2003/11/30#
>
> my wishlistCloseDate will be in the correct format, do I need to
> change the database field to match this?
>
You are missing the point. Dates are not stored with any format. In Access a
date/Time is stored as a Double, with the whole number portion representing
the number of days since the seed date, and the decimal portion representing
the time of day (0=midnight, .5 = noon, etc.).

So changing the Access-defined Format property of this date/time field will
have no effect on anything except how the dates are displayed _within
Access_.

According to the Access online help, literal dates in queries should be
formatted as US-style short dates: m/d/yyyy. However, we have discovered
that Jet has no problem dealing with dates in ISO format:
yyyy-mm-dd

I doubt that Jet will be able to handle this non-standard format you are
attempting to use for some reason.

All this silliness could be avoided if you used a saved parameter query. A
Google search should provide several examples of creating and using saved
parameter queries: many of them from me.

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"