Re: how to compare dates

[Ashish Bhatt <ashish_bhatt@HOTMAIL.COM>]

I am doing copy paste of my SQR code written last year

I hope it helps you. Use datediff.

   if (datediff(dateadd(strtodate(&Term_Dt,'MM/DD/YYYY'),'DAY',1),
               strtodate(&Hire_Dt,'MM/DD/YYYY'),'DAY') = 0 or
      datediff(dateadd(strtodate(&Term_Dt,'MM/DD/YYYY'),'DAY',1),
               strtodate(&ReHire_MMDDYYYY,'MM/DD/YYYY'),'DAY') = 0)
      if &Term_Dt = ''
         do Write-Line
         do Get-National-Id-Data
      else
         if (datediff(strtodate(&ReHire_MMDDYYYY,'MM/DD/YYYY'),
              dateadd(strtodate(&Term_Dt,'MM/DD/YYYY'),'DAY',1),'DAY') > 0
and
             datediff(strtodate(&ReHire_MMDDYYYY,'MM/DD/YYYY'),
                      strtodate(&Hire_Dt,'MM/DD/YYYY'),'DAY') > 0)
             do Write-Line
             do Get-National-Id-Data
         end-if
      end-if
   else
      do Write-Line
   end-if
----- Original Message -----
From: "Andalib Yussuf" <andalib.yussuf@AMS.COM>
To: <SQR-USERS@list.iex.net>
Sent: Thursday, July 25, 2002 10:59 AM
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
>