RE: [sqr-users] Prior Month

["Richard C Spoth" <Spoth.Richard@healthnow.org>]

SQR does have its own dateadd fucntion

let $date = dateadd($startdate, 'month', -1)


Rick Spoth





"Maria Ravanis" <Maria_Ravanis@skillsoft.com>
Sent by: sqr-users-bounces+spoth.richard=healthnow.org@sqrug.org
03/12/2004 09:56 AM
Please respond to "This list is for discussion about the SQR database 
reporting       language from Hyperion Solutions."

 
        To:     "This list is for discussion about the SQR database reporting 
language 
from Hyperion Solutions." <sqr-users@sqrug.org>
        cc: 
        Subject:        RE: [sqr-users] Prior Month


Unfortunately I am on SQL Server 2000

________________________________

From: sqr-users-bounces+maria_ravanis=skillsoft.com@sqrug.org on behalf of 
George Jansen
Sent: Fri 3/12/2004 9:49 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Prior Month



If you are using Oracle, Add_Months(Sysdate, -1) will work, for example

SQL> l
  1  SELECT Trunc(Add_Months(Sysdate, -1), 'Month')
  2* FROM dual
SQL> /

TRUNC(ADD_M
-----------
01-FEB-2004

SQL>


>>> Maria_Ravanis@skillsoft.com 03/12/04 09:26AM >>>
Does anyone have any code to identify the month prior based on the
system date?  I looked in the archives but couldn't get any of that
code
to work in my SQR.

Thanks - Maria

_______________________________________________
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



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





CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole 
use of the intended recipient(s) and may contain proprietary, confidential, 
trade secret or privileged information.  Any unauthorized review, use, 
disclosure or distribution is prohibited and may be a violation of law.  If you 
are not the intended recipient or a person responsible for delivering this 
message to an intended recipient, please contact the sender by reply email and 
destroy all copies of the original
message.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users