Could you post the context you are using this in (is it a query, string,
sp parameter etc)?

-----Original Message-----
From: Goutam Ghoshal
[mailto:mssqldba-ezmlmshield-x52993964.[Email address protected]
Sent: 28 February 2007 07:02
To: LazyDBA Discussion
Subject: Access Date query


Hi All

I have an Access DB
And there are some date/time fields in some tables.
But i have some problem to get data based on date query

Like in sql server we have lots of option to fetch data based on date
fieds (we can use convert etc)

suppose in a table there is a field name DOB
i want to fetch data whose DBB > '05/25/1969' ('mm/dd/yyyy')

How i get those records?

Regards,

Goutam




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment on the part of Optilan unless confirmed by a communication signed on behalf of the company.
Any email cannot be guaranteed to be secure, error free or free from viruses. Although every possible care is taken by Optilan, Optilan does not accept any liability whatsoever for any loss or damage which may be caused as a result of the transmission of this message by email.


MS Sql Server LazyDBA home page