[sqr-users] Date comparision

["radhika reddy" <radhika_05@hotmail.com>]

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