[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Date comparision

Do the date difference function found in delivered
datetime.sqc/datemath.sqc and then compare return code.

On 7/29/05, radhika reddy <radhika_05@hotmail.com> wrote:
> 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