Re: how to compare dates

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

and don't forget to declare the dates as date variables...

B
The Programmer formerly known as Bob
Mediware Information Systems Inc.
(913) 307-1045
Bob.Helm@Mediware.com


This message has been sent using 100% recycled electrons


-----Original Message-----
From: Hood Louise (app1lxh) [mailto:app1lxh@UPS.COM]
Sent: Thursday, July 25, 2002 1:26 PM
To: SQR-USERS@list.iex.net
Subject: Re: how to compare dates


Try datediff

-----Original Message-----
From: Andalib Yussuf [mailto:andalib.yussuf@AMS.COM]
Sent: Thursday, July 25, 2002 1:59 PM
To: SQR-USERS@list.iex.net
Subject: how to compare dates


Hello,
I was wondering how you can compare dates. For instance in SQL there is a
between function. How do I say

$doc_date  is between  '01/01' and '04/30'

I would appreciate your help in this matter.

Thank You

Anne