Comparing date in Access SQL query

Question

I'm having trouble with Access sql query. Im new to this so bieng a rookie its difficult to figure out the syntax. below is my query.

SELECT *
FROM BookingMaster WHERE JourneyDate = #01/08/2012#;

below is the respective table data:

BookingID   BookingDate    JourneyDate   CustomerName   TelephoneNo  Address
5            01-08-2012     01-08-2012         roshan         78889     hjgj

the above query listed returns 0 results even though data exist for 01/08/2012 journey date.

Can anyone please help me out.

Fionnuala · Accepted Answer · 2012-08-05 08:04:34Z

23

Unless you are working in a US locale, it is best to use a year, month, day format for dates:

SELECT *
FROM BookingMaster where JourneyDate = #2012/08/01#;

answered Aug 5, 2012 at 8:04

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

roshanK Over a year ago

if i have to compare..two date..with following format what i have to do..dd/mm/yyyy is there any format function...?

Fionnuala Over a year ago

Yes, there is. Format(ADate,"yyyy/mm/dd") for one (there are others) will return a string. It may not be available outside of Access. How you use dates with MS Access depends a lot on where you are working, the query design screen, VBA, outside of Access, etc.

kakarott · Accepted Answer · 2012-08-05 08:11:46Z

4

try this..

SELECT * FROM BookingMaster where (JourneyDate >= #01/08/2012#) and (JourneyDate < #01/09/2012#);

answered Aug 5, 2012 at 8:11

kakarott

2293 silver badges9 bronze badges

Collectives™ on Stack Overflow

Comparing date in Access SQL query

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related