Date Format / SQL Query..
Posted on 1999-11-05
I have a nice problem with the date format in my Access DB and a SQL query.
First of all some code:
//(table1 = CDaoRecordset*)
sel_time = table1->date_field.Format("%Y-%m-%d%H:%M:%S");
CString SQL_select = "select * from [table_name] where (\"Last Updated\" > DateValue(#" ;
SQL_select += sel_time;
SQL_select += "#) )";
Hope there are no typos....
Anyway. The problem I have is that the result of my query is the whole table "table_name" and not just the ones which have the correct date. As some of you might have guessed already the bug lies in the format of the date. My Access DB Date Format is "31.01.99" (good ol' european style).
Who paid attention and isn't confused (I am) and can help me before I go home and drink.
Thanks (cry for help......)