CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 greater than or equal (>=) not working in CCS 2.0

Print topic Send  topic

Author Message
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.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.