Stanj
Posts: 166
|
| Posted: 07/27/2010, 6:24 AM |
|
Hi CodeChargers
Haven't been around much lately, all my internal office projects are working.
I created a grid that has a column that is an event date in yyyy-mm-dd format from a MySQL DB and I wanted to create a SQL Where clause that limits the grid results to records after the current date. Using the MySQL date functions have not worked.
Sounds so simple but I've been playing for hours and no success. I have done several search forms in the past that I used date criteria but I do not have access to those project file right now and I just can't remember how I got them working.
Thanks for any suggestions......
[edit] Had a problem unrelated to this on the same record that prevented the records from being retrieved at all...
_________________
Stan
St Petersburg Russia |
 |
 |
|
