Failed to convert parameter val from Variant to DateTime
I have a parameter in my Query with dataType "DateTime" in the expression i tried a couple of things
like [DateTime.Now],DateTime.Now, DateTimePicker1.Value but nothing works.
What I want is the user input from DateTimePicker1 in my query.
datetime format in my query must be like '01-01-2013 00:00:00'
How do I do that???
like [DateTime.Now],DateTime.Now, DateTimePicker1.Value but nothing works.
What I want is the user input from DateTimePicker1 in my query.
datetime format in my query must be like '01-01-2013 00:00:00'
How do I do that???