Hello all-
I have a sql statement that accesses a dBase V directory. All of my sql statements have worked thus far, but when I attempt to retrieve date data, it comes up blank. This is my Where clause:
Where CZVOID.Date >= #" & DTPicker2.Value & "# And CZVOID.Date <= #" & DTPicker1.Value & "#
DTpicker1 and 2 allow the user to pick a date range to search. I have grabbed the sql statement before it makes the connection to test it in Access (with linked tables) and it comes up fine. Does ODBC handle the dates differently than Access? Thanks in Advance.
BKtechie
I have a sql statement that accesses a dBase V directory. All of my sql statements have worked thus far, but when I attempt to retrieve date data, it comes up blank. This is my Where clause:
Where CZVOID.Date >= #" & DTPicker2.Value & "# And CZVOID.Date <= #" & DTPicker1.Value & "#
DTpicker1 and 2 allow the user to pick a date range to search. I have grabbed the sql statement before it makes the connection to test it in Access (with linked tables) and it comes up fine. Does ODBC handle the dates differently than Access? Thanks in Advance.
BKtechie