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 ?
Name E-mail optional TopicMessage:
HTTP Link: Link text: