Re: DATE QUAL IN SQL

["Jay Vaughn" <jayv@xxxxxxxxxxxxxx>]

thanks fellas... as you spotted right off, it was the CURDAT that was the 
issue.  Not sure where I got that from?
 
Thanks,
 
Jay Vaughn
Senior I5 Programmer/Analyst
RateWatch
(P) 251.633.8929
(F) 251.633.8929
www.rate-watch.com


-----Original Message-----
From: "Francis Lapeyre" <flapeyre@xxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Date: Tue, 4 Dec 2007 15:07:31 -0600
Subject: Re: DATE QUAL IN SQL


Use CURRENT DATE instead of CURDAT (I'm assuming that you have a UDF called
idate that returns a native date).

On Dec 4, 2007 2:50 PM, Jay Vaughn <jayv@xxxxxxxxxxxxxx> wrote:

>  i need only those records in last 7 days...
>
> I am using, WHERE idate(QFDATE) >= (CURDAT - 7 DAYS)
>
> but it doesn't seem to like it... what am i missing?
>
> Thanks,
>
> Jay Vaughn
> Senior I5 Programmer/Analyst
> RateWatch
> (P) 251.633.8929
> (F) 251.633.8929
> www.rate-watch.com
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.