Date format in query

**aman1234** · 03-04-2015, 12:06 PM

Hi guys

The following query doesn't display anything. I think the problem is in the date format. ANy help would be much appreciated.

Please Login or Register  to view this content.

Thanks

**romperstomper** · 03-04-2015, 12:18 PM

Typically you'd pass the date in mm/dd/yyyy form to Access. Given that your date is a literal, you can just type it that way round.

**aman1234** · 03-05-2015, 05:41 AM

Thanks romperstomper, 04/03/2015 means 4th March 2015 so if I write the sql query as below then it doesn't pull anything from access table.

Please Login or Register  to view this content.

Please suggest me what shall I do?

**aman1234** · 03-05-2015, 06:05 AM

i tried as below and it worked fine.

Please Login or Register  to view this content.

Re: Date format in query