Re: how to compare dates

[Ramzi Salameh <Ramzi_Salameh@DAVEANDBUSTERS.COM>]

You can do:

($doc_date >= '01/01' AND
 $doc_date <= '04/30')

hth

------------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.

Voice     (214) 904-2550
Fax       (214) 350-0941
------------------------------------------------



                      Andalib Yussuf
                      <andalib.yussuf@A        To:       SQR-USERS@list.iex.net
                      MS.COM>                  cc:
                      Sent by:                 Subject:  how to compare dates
                      "Discussion of
                      SQR, Brio
                      Software's
                      database
                      reporting
                      language"
                      <SQR-USERS@list.i
                      ex.net>


                      07/25/02 12:59 PM
                      Please respond to
                      sqr-users






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