SQLquery = "select * from PT13 "
SQLquery &= " WHERE UPDAT_DATE BETWEEN '" & frmselectDate.DateTimePicker1.Value And frmselectDate.DateTimePicker2.Value & "'"
Tag : .NET, Ms SQL Server 2008, Win (Windows App), VB.NET, VS 2010 (.NET 4.x)
SELECT *
FROM PT13
WHERE UPDAT_DATE BETWEEN '" & DateTimePicker1.Value.Tostring("yyyyMMdd") &"' AND '" & DateTimePicker2.Value.Tostring("yyyyMMdd") &"'