rbell
|
Posted: 12/12/2003, 5:09 AM |
|
When I try and get back all results greater than or equal to today date, it doesn't bring back today’s date but it will bring back all the other dates.
However when I try and do the reverse and use less than or equal to it works fine and brings back today’s date
Any ideas??
Thanks.
Ray.
|
|
|
Nicole
|
Posted: 12/15/2003, 6:06 AM |
|
Ray,
What database you’re using?
I believe that it’d be easier to find out what’s wrong if you print the generated query and test it against the database. May be he problem is in specific data stored in the table.
I’m not sure what programming language you’re using so I do not provide the sample code that prints the query, you can check the code in the CCS help. Use Before Build Select event and print both SQL and WHERE.
|
|
|
|