CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge -> General/Other

 Search between dates in asp

Print topic Send  topic

Author Message
Posted: 07/19/2005, 4:57 AM

I created a search form and a grid form for the results display. I need to add a search criteria date from - date to. Meaning two dates start date and end date. Does any one know how to do this in Code Charge 2.0. I am using asp and access database.

Appreciate help


Posts: 586
Posted: 07/19/2005, 5:25 AM

The set up for Input parameters of Date type is usual, there’s nothing special that worth attention. But to make search on dates work properly the date should be passed to a database in the format in which it is stored in a database.
E.g. if search date parameter is
27/03/2005 and database accepts dates in yyyy-mm-dd format the search does not return a valid result. The date should be converted to database date format (yyyy-mm-dd in this sample) before.
This article describes how to format dates in CC projects
Hope it helps.

View profile  Send private message
Posted: 07/19/2005, 9:46 AM


Send me your email address and I'll send you a .ccs that I put together using CC 2.0, Access and ASP.

It has an example of a calendar that is searchable between a starting and ending date.


Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login

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