RE: [sqr-users] Date comparision

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Strtodate converts a string that looks like a date to a date value.  Edit
converts it back to a string.  If you want to work with strings, you have to
format them like 'YYYY-MM-DD'.  But you can also work with dates, starting
in SQR version 6.  You would have to declare the variables as date variables
first.

begin-setup
declare-variable
date $date1 $date2
end-declare
end-setup

let $date1 = strtodate($load-date, 'DD-MON-YYYY')
let $date2 = strtodate('01-JAN-2006', 'DD-MON-YYYY')
if $date1 < $date2
....


-----Original Message-----
From: radhika reddy [mailto:radhika_05@hotmail.com]
Sent: Friday, July 29, 2005 2:28 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Date comparision


Hi,

    I have to check whether the $load-dt is less than $Union-date( 
'1JAN2006' ) which is always constant. When my $load-dt  is '17FEB2005' it 
is not going into the IF loop but when I changed my $Union-date to 
'1Mar2006' cursor is going into the IF loop.

Why is it that it is not looking at the year?

Here $load-dt  = ' 02/17/2005'
Let $load-dt = edit(strtodate($load-date,'DD-MON-YYYY'),'MM/DD/YYYY')
Let $Union-date = edit(strtodate('01-JAN-2006','DD-MON-YYYY'),'MM/DD/YYYY')

  IF $load-dt < $Union-date

          show 'enter ben.planRSP'
          Let $benefit_plan                     =  'RSP'

   End-If

Any help would be great.

Thanks.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users