QBE and English date selection

by Jon Grosse, October 23, 2006 01:02

Using Access97 with English date formats.

I cannot find the way to select a date for QBE except by entering a date in the USA fashion.

I have

SETOPTION DATE="ymd";

FORMAT TestDate="dd/mm/yyyy";

This displays TestDate as 18/10/06 in the table - which is what I need. However, if I use QBE for selection, I am only successful if I enter the date as 10/18/06.

How can I perform a QBE selection on 18/10/06 ?

Replies:

• Try this..., Roger Harris, 11-04-2006
Next | Previous | Top

Post Your Reply:

Name   
E-mail  optional
Topic  

HTTP Link: 
Link text: