Problem of Date Field Selection

[ctkmak]

I have a table to store the new append records from a SQL statement. In this table I have defined a "Status Date" in field type date/time with format dd/mm/yyyy. However, when execute the SQL append statement, the system has appended the record with format of dd/mm/yyyy hh:mm:ss.

The problem is when I run the report with a date range input, the report cannot select any records with such date range. I have examined the table format is correct, but I found the data actually included the time in it. Do anyone know how to overcome this problem?

 

[Rich]

Post the SQL statement

 

[RoyVidar]

Ary you by any chance using the Now() function (date and time) in stead of the Date() function? That could explain it.

Remember the format is just about visual apperance, not what's actually stored.