Dear Ranjan BANERJI, I would like to thank you for your reply but I feel that I have to exemplify my problem a bit more: I am able to extract the date portion from the user-supplied date but I am not able to do the same for the date retrieved from the database. What I need is the name of the SQL function that does this. Thank you for your time, Christos P.:)

Hi all, I am using a Crecordset class to retrieve rows from an access database table. I am constructing the WHERE statement at runtime and pass it to CRecordset using m_strFilter. The problem is the following: I need to query a date field in the database (rem_date) based on a date provided by the user (m_date). I am using the following code (v_filter is the where statement): v_filter+="(rem_date="; v_filter+="{d'"; v_filter+=m_date.Format("%Y-%m-%d");:confused: v_filter+="'}"; v_filter+=" )"; The problem is that the above statement returns TRUE only when both the date and the (hidden) time is the same. I only need to compare the date portion. Do you know how can I do this? I thank yuo in advance, Christos P.

Hi all, I have developed a simple database application which accesses data stored in an Access database using CRecordset. The problem is that I cannot directly see the changes that I make to the database. For example, if I insert a new record, close the recordset, open the recordset and read all records, I cannot immediately see the newly added record. In all cases, if I wait for 2-3 seconds and then read the database, I can see the newly added record. I guess that for some reason my data are not immediately stored in the database. What can I do? I have also tried with transactions (commit) but the problem remains.:confused: I thank you in advance, Christos P.