'Datepicker format in vb.net to ms access Feb 11, 2022 read as Nov/02/2022

Datepicker format in vb.net to MS access Feb 11, 2022 read as Nov/02/2022

Here is my code

strSQL = "SELECT * " &
 "FROM Payroll " &
 "WHERE EmpID = '" & strSelectedAssignCode & "' And FromPay = #" & dtpFromPay.Value.Date & "# And ToPay = #" & dtpToPay.Value.Date & "#"


cnOleDb = New OleDbConnection(ACCESS_CONNECTION_STRING)
cnOleDb.Open()

cmSQL = New OleDbCommand(strSQL, cnOleDb)
drSQL = cmSQL.ExecuteReader()

enter image description here

vb.netdatepicker


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions