CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Showing records < 30 days old?

Print topic Send  topic

Author Message
Geary
Posted: 04/19/2003, 7:06 PM

Hi everyone

I'm trying to filter a grid to only show records if they are less than 30 days old.

Can someone help me with this?


TIA

Geary
Karen
Posted: 04/20/2003, 7:09 AM

What are your table fields like? If you have a timestamp or age in days field, then use this field as an expression (criteria) in the query builder. Hope that helps.
Geary
Posted: 04/20/2003, 8:30 AM

Yes, the date is added to the DB when the record is created. How do i get tot he query builder?

:)

TIA

Geary
DaveRexel
Posted: 04/20/2003, 11:27 AM

Hello Geary

This thread might help, see the replies by RonB as they are most relevant

http://www.gotocode.com/disc_viewt.asp?mid=19793&

Greetings
Dave

CCS Knowledge Base
http://www.rexdesign.com/ccs/default.php

   


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

Web Database

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.