[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] COMPARE DATE
- Subject: Re: [sqr-users] COMPARE DATE
- From: "Chuyen Do" <cdo@umuc.edu>
- Date: Fri, 19 Nov 2004 17:05:28 -0500
- Delivery-date: Fri, 19 Nov 2004 17:06:52 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Organization: University of Maryland University College
- References: <372DD7320F873B43929D49BFF86F950B095C3156@mail3.hexaware.com>
Thank you Murty.
Chuyen
Murty Mirthipati Venkata Suryanarayan wrote:
>
> Chyen,
> Date variables are recognized with $, but not with #. Also, assignment
>statements are done using let command. I suppose the sysdate in if condition
>is the current date.
>
> Your code should be like:
> let $date = '20041119'
> let $sysdate = strtodate(datetostr(datenow(), 'YYYYMMDD'))
> if $date > $sysdate
> do procedure 1 ! ... bla bla...
> end-if
> Murty ;)
>
>
> -----Original Message-----
> From: Chuyen Do [mailto:cdo@umuc.edu]
> Sent: Fri 19-Nov-2004 16:34
> To: sqr-users@sqrug.org
> Cc:
> Subject: [sqr-users] COMPARE DATE
>
>
>
> Please HELP me the syntax:
>
> #DATE_to_be_compared = 20041119
>
> if #DATE_to_be_compared > sysdate !it means date at the time the
> program do .. ! is running.
> end-if
>
> I don't know the reserved name for sysdate
>
> Thanks
> Chuyen Do
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
> DISCLAIMER:
> Information contained and transmitted by this E-MAIL is proprietary to
> Hexaware Technologies and is intended for use only by the individual or
> entity to which it is addressed and may contain information that is
> privileged, confidential or exempt from disclosure under applicable law.
> If this is a forwarded message, the content of this E-MAIL may not have
> been sent with the authority of the Company. If you are not the intended
> recipient, an agent of the intended recipient or a person responsible
> for delivering the information to the named recipient, you are notified
> that any use, distribution, transmission, printing, copying or
> dissemination of this information in any way or in any manner is
> strictly prohibited. If you have received this communication in error,
> please delete this mail & notify us immediately at
> adminchn@hexaware.com.
>
> ------------------------------------------------------------------------
> Here was a non admissible message part of 'application/ms-tnef' MIME
> type. It has been automatically discarded before sending the message to
> the list.
>
> ------------------------------------------------------------------------
> _______________________________________________
> 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