RE: [sqr-users] COMPARE DATE

["Bartlett, Dwain" <dbartlett@state.mt.us>]

Maybe you should take a class.  Obviously you don't know Jack.

Dwain Bartlett
SABHRS Services Bureau, ITSD
HR Systems Analyst
(406) 444-0418
dbartlett@state.mt.us


-----Original Message-----
From: Chuyen Do [mailto:cdo@umuc.edu]
Sent: Friday, November 19, 2004 2:53 PM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: Re: [sqr-users] COMPARE DATE


I am not clear !!!

I have the "datenow" then how can I switch to #curr_date = 20041119
then I can compare later. ??

Thanks.

Jeff.Steinfeldt@wellsfargo.com wrote:
> 
> DATENOW()
> 
> Returns the current local date and time from the client machine.
> 
> Syntax: dst_var=datenow()
> 
> dst_var = date variable
> Example: let $date=datenow()
> 
> -----Original Message-----
> From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
> [mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
> Behalf Of Chuyen Do
> Sent: Friday, November 19, 2004 3: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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users