MS SQL Server:
SET DATEFORMAT dmy;
SELECT Enquiry.Enqid AS SLNO,Enquiry.Phone,
Enquiry.mobile, Enquiry.custname,Enquiry.email,
Enquiry.enqdate,Enquiry.enquirysource,
Enquiry.workdescription from Enquiry
where
enqdate<='06-01-2013'
MS Access:
SELECT Enquiry.Enqid AS SLNO,Enquiry.Phone,
Enquiry.mobile, Enquiry.custname,Enquiry.email,
Enquiry.enqdate,Enquiry.enquirysource,
Enquiry.workdescription from Enquiry
where
enqdate<=#06-01-2013#
Do you see the difference?
[EDIT #1]
ALTER PROCEDURE SEL_Enquiriesdate
@enqdate DATETIME
AS
BEGIN
SET NOCOUNT ON;
SET DATEFORMAT dmy;
SELECT Enqid AS SLNO, Phone, mobile, custname, email, enqdate, enquirysource, workdescription
FROM Enquiry
where enqdate<=@engdate
[/EDIT]