[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 16:57:19 -0500
- Delivery-date: Fri, 19 Nov 2004 17:05:07 -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: <0470908F86319A4F83F01319532FBEEA616D29@isifmail.isif.state.id.us>
Hi Jon,
I feel good now, I'll try
Many thanks.
Chuyen.
Jon Alsager wrote:
>
> In your example, I believe to_number(datetostr(datenow(),'YYYYMMDD'))
> would work.
>
> Jon
>
> -----Original Message-----
> From: sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org
> [mailto:sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org] On Behalf
> Of Chuyen Do
> Sent: Friday, November 19, 2004 2:34 PM
> To: sqr-users@sqrug.org
> 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
>
> _______________________________________________
> 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