conversion functions.

M

Mr. x

Hello,
In sql query - how can I compare date column to a specific date,
i.e
select ....
where my_date_column <= "17/9/2003"
, which doesn't work ...

Besides, where can I find good help for access database (I preffer a *.chm
file).

Thanks :)
 
B

Bruce M. Thompson

In sql query - how can I compare date column to a specific date,
i.e
select ....
where my_date_column <= "17/9/2003"
, which doesn't work ...

You need to enter your date criterium in the "m/d/yyyy" format. Other formats,
such as "d/m/yyyy" will not be property recognized in Jet SQL.

As for help for Access, there are numerous websites where you can get help, or
links to the same, such as:

Tony Toews' Main Access Page
http://www.granite.ab.ca/accsmstr.htm

The Access Web
http://www.mvps.org/access/

And the links page at The Access Web
http://www.mvps.org/access/resources/othersites.htm
 
B

Bruce M. Thompson

Well,
I have tried :
... where my_date_column <= "9/17/2003".
and query doesn't work either.

Try inserting the date delimiter (#):

<= #9/17/2003#
 
B

Bruce M. Thompson

Where can *.chm file for database access ?

I am unaware of any CHM (html help) files that are available for additional help
in Access. You might try a search at http://www.google.com.
 
M

Mr. x

Well,
I have tried :
.... where my_date_column <= "9/17/2003".
and query doesn't work either.

Thanks :)
 
V

Van T. Dinh

If you use Office / Access XP, there should be quite a
few .CHM files already on your computer. Search for these
files:

actoc10.chm
acmain.chm
vbaac10.chm
vbaof10.chm
DAO360.chm
ADO210.chm
JETSQL40.chm
JETDEF40.chm
MSJRO.chm
JETERR40.chm
....

There are a few more that relate to Access / Office / VBA.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top