How to search between two dates in CCS Studio

CodeCharge Studio

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

How to search between two dates in CCS Studio

Author

Message

Bob Chien

Posted: 10/05/2002, 9:34 AM

How to design the search form in CCS to query the database between two values. For example: I'd like to query between 8/12/02 and 9/31/02? I know you can do this in CodeCharge Generator, but how in Studio?

Thanks.

Tom

Posted: 10/07/2002, 6:59 AM

I did this in a search form by creating two fields s_BegDate and s_EndDate
I then modified the grid table parameters to create two 'where' clauses
mydate >= url.s_BegDate
AND
mydate <= url.s_EndDate

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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login