infotba
|
| Posted: 09/28/2002, 12:26 AM |
|
Please give me information.
How can I search the events between specific(both of them entered from text box) two dates ?
Regards
|
|
|
 |
Nicole
|
| Posted: 10/01/2002, 7:16 AM |
|
Hello,
this is db dependent issue. First of all (and it is necessary for all the dbs) you should format date into db date format. So you should convert date into db date format before using it in the query.
In case you're using CCS you should check the following:
1. in server side connection settings select proper db date format. In case db has several date type fields select/type in the most full one;
2. on the grid form: in case the date field format is different from one mentioned in paragraph #1, select/type in appropriate date format into field DBFormat property;
3. when adding table parameters in the form DataSource dialog: in case the date field format is different from one mentioned in paragraph #1, select/type in appropriate date format in the Field 'Format' property.
If you're building site with CC please refer to the following article that demonstrates how to convert dates into different formats: http://www.gotocode.com/art.asp?art_id=132&
|
|
|
|
|
