hi ,how to change the sql query date between as below startdate and enddate string??i want to use date between query from excel vba to retrieve data from sql server.please help.thanks.

Code:
Dim enddate As String
Dim startdate As String
Dim partno As String

partno = ComboBox1.Text
startdate = Format(Dtpdata.DTPicker1.Value, "dd MMM yyyy")
enddate = Format(Dtpdata.DTPicker1.Value, "dd MMM yyyy")

“SELECT SpcData.PartNo, SpcData.Dimension, SpcData.MachineNo, SpcData.Date FROM SPC.dbo.SpcData SpcData WHERE (SpcData.Date Between {ts '2008-03-24 00:00:00'} And {ts '2008-03-27 00:00:00'}) AND (SpcData.PartNo='" & partno & "') GROUP BY SpcData.PartNo, SpcData.Dimension, SpcData.MachineNo, SpcData.Date