Hi guys
When I use the format command with date or time as in the following query then it gives me compile error Expected End of statement.
Can anyone please tell me how can I change the format of date or time in select statement.rs.Open "Select NewBatch as BatchNum,format(ScanDate,"dd/mm/yyyy") ,format([Time],"hh:mm") as [Request Time],pages from tblmain where Department='" & ComboBox1.Value & "' and date1=# " & Format(TextBox1, "dd/mm/yyyy") & " # ", cn
Regards
Aman
Bookmarks