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
|
|
|
 |
|