[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: how to compare dates
- Subject: Re: how to compare dates
- From: "Lipka, Jason" <Jason.Lipka@GOV.CALGARY.AB.CA>
- Date: Thu, 25 Jul 2002 13:28:25 -0600
- Importance: normal
- Priority: normal
- Thread-index: AcI0EUZnbokokRDQTa+ZovmexVBMWgAAKErg
- Thread-topic: Re: how to compare dates
try this
If $doc_date >= '10/01' and $doc_date <= '12/31'
jay
-----Original Message-----
From: Andalib Yussuf [mailto:andalib.yussuf@AMS.COM]
Sent: 2002 July 25 1:23 PM
To: SQR-USERS@list.iex.net
Subject: Re: how to compare dates
Hello Rick,
thanks for the quick reply. I have provided my code below and I did use the
datetostr function. This is what I have and it is not working
h.DOC_DT &doc_date
let $doc_date = datetostr(&doc_date, ('MM/DD'))
If $doc_date >= '10/01' and <= '12/31'
let $quarter = '1'
else If $doc_date >= '01/01' and <= '04/30'
let $quarter = '2'
else If $doc_date >= '05/01' and <= '06/30'
let $quarter = '3'
else If $doc_date >= '07/01' and <= '10/31'
let $quarter = '4'
End-If
The current error I get is '<=' missing arguments