DTPicker control

Hi,

Can someone tell me what is the data type of DTPicker control. I tried using 'valtype' and it said Date.
But I can't seem to be able to extract a recordset based on date range.
This is my code:

Adodc2.RecordSource = "SELECT Ta_ITEMTRN.CODE, Ta_ITEMTRN.TRNDATE, " & _
"FROM Ta_ITEMTRN WHERE Ta_ITEMTRN.CODE='" & itemcode.BoundText & "' " & _
"Ta_ITEMTRN.TRNDATE>=#" & Ctl_sdate & "# AND Ta_ITEMTRN<=#" & Ctl_edate & "#"
Ctl_sdate and Ctl_edate are DTPicker control.
When it's run, it just pull all records belong to ta_itemtrn.code instead of what I want.
Can someone help ?

You might wrap your date picker values with CDate() just to make sure the values are converted to a date that your system likes. You might also specify Ctl_sdate.Value or whatever property it is that returns the date value of the control.

You don't mention your database type. If it's Access, then wrapping your dates with '#' is the way to go, if it's SQL Server you should wrap your dates with single quotes instead of pound signs.

Good luck,
Paul

hi Paul,

I'd tried the cdate() before but it does work, nothing was extracted.
by the way, my database is access 2000 format.
strange thing is when I use '#', it extract records up till the Ctl_edate but it also include records that is before Ctl_sdate. In other words, it basically pull out 1st record to the Ctl_edate.

sorry, there is a typo mistake in my earlier message:

Using CDate does NOT work.

How about this... In your SQL statement you have:

"Ta_ITEMTRN.TRNDATE>=#" & Ctl_sdate & "# AND Ta_ITEMTRN<=#" & Ctl_edate & "#"

and shouldn't it read:

"Ta_ITEMTRN.TRNDATE>=#" & Ctl_sdate & "# AND Ta_ITEMTRN.TRNDATE<=#" & Ctl_edate & "#"

It looks like you left the .TRNDATE off the second compare. Coulda been a typo in your post. I'm not sure if the SQL statement would work at all as written but I don't use Access 2000.

Maybe?

Paul

paul, you're right, it was a typo too, not in my code but in my message.
Theorically it should work but it just wouldn't give me what I want.
oh god, it's driving me nuts.