ODBiC Discussion Board


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:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.