Greater than date

[andrew3254]

Hi,

I seem to be having with querying a date, I want to return all records that
have a date >= 01/04/2008, in other words anything from the beginning of
april.

I have used ">=#01/04/2008#" and it returned no records, if i remove the
criteria to show all records i can see there are dates that met the criteria.

Here is my SQL syntax:

SELECT [Tbl_Bid Details].[Quote Number], [Tbl_Bid Details].Customer,
[Tbl_Bid Details].Description, [Tbl_Bid Details].Status, [Tbl_Bid
Details].[Date RFQ Received], [Tbl_Bid Details].[Job Won]
FROM [Tbl_Bid Details]
WHERE ((([Tbl_Bid Details].[Date RFQ Received])>=#1/4/2008#) AND (([Tbl_Bid
Details].[Job Won])=Yes));

 

[Allen Browne]

Regardless of your regional settings, JET expects the date in a SQL
statement to be in US format. Use #4/1/2008#.

More info about how to ensure Access understands your dates correctly:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I seem to be having with querying a date, I want to return all records
that
have a date >= 01/04/2008, in other words anything from the beginning
of april.

I have used ">=#01/04/2008#" and it returned no records, if i remove the
criteria to show all records i can see there are dates that met the
criteria.

Here is my SQL syntax:

SELECT [Tbl_Bid Details].[Quote Number], [Tbl_Bid Details].Customer,
[Tbl_Bid Details].Description, [Tbl_Bid Details].Status, [Tbl_Bid
Details].[Date RFQ Received], [Tbl_Bid Details].[Job Won]
FROM [Tbl_Bid Details]
WHERE ((([Tbl_Bid Details].[Date RFQ Received])>=#1/4/2008#)
AND (([Tbl_Bid Details].[Job Won])=Yes));