Date format in query

[aman]

Hi Guys

I am writng code in excel VbA that will fetch data from Access table.

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.

strsql = "SELECT DISTINCT printpoolno FROM tblmaster where username='" & Application.UserName & "' AND Date1=#" & Format("04/03/2015", "mm/dd/yyyy") & "#"
    MsgBox strsql

Please suggest me what shall I do?

 

[Mile-O]

Try:

Format(DateValue("04/03/2015"), "mm/dd/yyyy")

It probably doesn't recognise the string as a date in order to format it appropriately.

 

[aman]

It worked fine. Thanks Mile-O