hello
i want to access the data from sql server which lies in particular date . I select the date from my vb form DTPicker and my query is
Str3 = "SELECT * FROM New_Rec where From_Date = # " & Format(DTPFrom & " 00:00:00", "dd/mm/yyyy hh:mm:ss AMPM") & " # AND To_Date = # " & Format(DTPTo & " 23:59:59", "dd/mm/yyyy hh:mm:ss AMPM") & "#"
where from_date and To_date are date column and DTPFrom , DTPTo are DTPicker .
In DTPFrom, the format of value is 01\dec\2007 07:00 AM
in DTPTo , the format of value is 04\apr\2007 02:30 PM
can i change the format of DTPicker or chechk the query and give perfect code