Date Restriction in SQL query

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have the following SQL query on a database and would
like to restrict data from a given date. ie. I would like
to insert >#31/05/2004# into the statement below.

SELECT tblEnquirer1.*, tblEnquiryType1.EnquiryType
FROM tblEnquirer1 INNER JOIN tblEnquiryType1 ON
tblEnquiryType1.EnquiryTypeID=tblEnquirer1.EnquiryTypeID;

How could I do this? thanks
 
You don't say what the name of the field is that should be filtered by your
expression, so here is a generic modification to your query:

SELECT tblEnquirer1.*, tblEnquiryType1.EnquiryType
FROM tblEnquirer1 INNER JOIN tblEnquiryType1 ON
tblEnquiryType1.EnquiryTypeID=tblEnquirer1.EnquiryTypeID
WHERE [DateTimeField] > DateSerial(2004, 5, 31);


I used DateSerial because Jet requires US format if you use "string" dates,
and depending upon your Local Settings, using dd/mm/yyyy format might be
misinterpreted. However, if your local settings are for dd/mm/yyyy, then you
could use this:

SELECT tblEnquirer1.*, tblEnquiryType1.EnquiryType
FROM tblEnquirer1 INNER JOIN tblEnquiryType1 ON
tblEnquiryType1.EnquiryTypeID=tblEnquirer1.EnquiryTypeID
WHERE [DateTimeField] > "#" & Format("31/05/2004", "mm/dd/yyyy") & "#";
 
Back
Top