Hei,
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,
