Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
I have a problem in a Query
I have a problem with the below query. It gives me the error in Date format. Means query produce syntax error.
sql = "select ms.Match_Number,ms.Match_date_Time from Season s,leauge l,Match_Schedule ms where s.Season_Id=ms.Season_Id and s.Season_Year=" & cmb_Season_Year.Text & " and l.leauge_Id=ms.Leauge_Id and l.Leauge_Name='" & cmb_Leauge_Name.Text & "' and ms.Match_Date_Time=#" & Format(cmb_Date_Time.Text, "DD.MM.YYYY" & " " & "hh:mm:ss") & "# order by ms.Match_Number"
Can you please help me in this regard. I shall be very thankful to you.
Regards,