Tam
|
| Posted: 09/13/2004, 1:37 PM |
|
I have a datetime field datetime_submitted and its property as following:
Default Value: CurrentDateTime
DBFormat: yyyy-mm-dd HH:nn:ss.
As I create a search form having a s_datetime_submitted whose value retrieved from DatePicker, I get "No records" all the time. I think the problem is that the datetime_submitted field has value of date and time (which I want) while the search field has only date value.
Please suggest how to make the search work.
Thank you.
|
|
|
 |
Rookie
|
| Posted: 09/13/2004, 2:34 PM |
|
specify what Database are you using, if it´s Access, the best way to avoid this problem is to chance the datasource of the grid from table to SQL and specify the date parameter between #datefield#. It seems there´s a problem using date search, and this was the only way I could pass tru it... 
|
|
|
|
Tam
|
| Posted: 09/14/2004, 10:04 AM |
|
First, thanks for reply. My database is MySql, and it has 2 datatypes: Date and Datetime. The Date datatype is fine, but since I also want to keep the time while able to search by date, I got problem.
As you said there's a problem using date search, all I do is to use the CodeCharge Builder. So, where is the problem coming from? The software iftself, you think?
Thanks.
|
|
|
|
|
