RE: [sqr-users] Date comparision

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

Thanks Steve. Both worked i.e., comparing strings and also dates.


>From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "'This list is for discussion about the SQR database 
>reportinglanguagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Date comparision
>Date: Fri, 29 Jul 2005 15:33:32 -0700
>
>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

_________________________________________________________________
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