PDA

View Full Version : Date Range Filter


Gareth Horton
July 12th, 2002, 02:32 PM
Nicholas,

Works like a charm once I realized I was keying in 08/26/2002 instead of 08/26/2001!

Thanks much for the help. Glad I found the forum. This has been bugging me for a long time.

Has anyone put up a web page yet with good examples such as these?

Allen

Nicholas Osdale wrote:
> sure, (replace [DateField] with your field:,$s:LF>
> [DateField] > {08/26/2002} .And. [DateField] <{09/30/2001}
>
> This results in all dates between the given dates, to include those dates use:
>
> [DateField] >= {08/26/2002} .And. [DateField] <= {09/30/2001}
>
> Allen Sanford wrote:
> > Hi All,
> >
> > In Monarch Pro 5 is there any way to use a date range in a filter?
> >
> > ex. >8/26/01 <9/30/01
> >
> > Basically I'm trying to filter between 8/26/01 and 9/30/01.
> >
> > Any help will be much appreciated.
> >
> > Allen
> >
>