0

how to search months name and year using dtpicker?

i use this format for months and year in formload..
DTPicker1.CustomFormat = "MMMM, yyyy"

but when i use this for searching.. it doesn't see what month and yr that i inputed

this is my code:

.Open ("SELECT * from qryRTS WHERE RTSDate = #" & DTPicker1 & "#"), conn, 3, 3

need help.. thanks

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by AndreRet
0

Add the DateValue statement to get the correct data -

.Open ("SELECT * from qryRTS WHERE RTSDate = DateValue('" & DTPicker1.Value & "')", conn, 3, 3
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.