CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Help with showing grid items where date<7days

Print topic Send  topic

Author Message
Frank Rocco
Posted: 04/18/2002, 9:48 AM

Hello,

I'm trying to create a grid to show users records where the call date is
less than 7 days old.

I'm using access database and ASP 2.0 (no templates).

I can't seem to get this to work.

Thanks

Frank

keijen
Posted: 04/18/2002, 2:41 PM

Try
WHERE calldate BETWEEN date() AND date()-7


"Frank Rocco" <farocco@hotmail.com> wrote in message
news:a9mtcd$97u$1@news.codecharge.com...
> Hello,
>
> I'm trying to create a grid to show users records where the call date is
> less than 7 days old.
>
> I'm using access database and ASP 2.0 (no templates).
>
> I can't seem to get this to work.
>
> Thanks
>
> Frank
>
>

Frank Rocco
Posted: 04/18/2002, 6:45 PM

Thanks, I'll try that.

Regards,

Frank


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.350 / Virus Database: 196 - Release Date: 4/17/2002


   


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.