Lorenz
|
| Posted: 05/28/2002, 1:46 AM |
|
Hello, this is my problem :
I have a "search" form and a "grid" form.
I have to insert in a textbox a "date" to be searched, the "date" is in this type : yyyy-mm-dd , and I have to search all dates from the "date" inserted (>=).
If input in grid form is declared date it give me an error, if it is text or number the searching don't match.
Have I to separate the search in three fields? (I hope no!:))
Thanks
|
|
|
 |
Nicole
|
| Posted: 05/28/2002, 2:11 AM |
|
Lorenz,
What is your db type?
In case you work with MySQL (you use mysql date format) you should enter date in yyyy-mm-dd format on the search form. On the Grid form add it as Input parameter of Text type (as date fields in MySQL are to be surrounded with quotes), assign it to proper field and select Operation.
In case you work with Access, then you should surround date value with hashes (e.g. #05-28-2002#). You should use replace code in form Open event to add hashes to date value.
|
|
|
|
Lorenz
|
| Posted: 05/28/2002, 2:25 AM |
|
It is an Access db, now it works!
I'm very grateful!
|
|
|
|
|
