作者: X-Engineer 時間: 2016-12-12 15:29 標題: SQL in VB - Search between two dates
本帖最後由 X-Engineer 於 2016-12-12 15:45 編輯
結果出來的是, 由12/12/2016至31/10/2017
不知為何
Please HELP, THANKS Bro!!
SELECT [Employee Number], [Chinese Name], [English Name], [Tel Number], [Expiry Date] FROM Employee Where [Expiry Date] between #12/12/2016# and #11/1/2017#
- Dim con As OleDbConnection
- Dim da As OleDbDataAdapter
- Dim dt As New DataTable
- Dim today = DateTime.Now.Date
- Dim an1 = today.AddDays(+31)
- Dim an2 = today.AddDays(+61)
- con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=|DataDirectory|\IWSDatabase.accdb")
- con.Open()
- da = New OleDbDataAdapter("SELECT [Employee Number], [Chinese Name], [English Name], [Tel Number], [Expiry Date] FROM Employee Where [Expiry Date] between #" + an1.Date + "# and #" + an2.Date + "#", con)
- da.Fill(dt)
- NotifyDataGridView.DataSource = dt.DefaultView
- con.Close()
作者: kckcp 時間: 2016-12-12 16:01
Expiry Date 個 datatype 系DATE 既話 , 甘an1.Date 最好加 : an1.Date.tostring("yyyy-MM-dd")
an2 都系
作者: yjfoeg 時間: 2016-12-12 16:05
原因就係default用緊en-us format，即係MM/dd/yyyy...
咁你個query就變成2017年11月1日
作者: X-Engineer 時間: 2016-12-12 17:11
Thank you so much!
It works now. ^.^