RE: [sqr-users] currentdate - one month

["Aruna Chandrasekharapuram" <arunacc@hotmail.com>]

Try this -

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

where $startdate is datenow() i.e., current date in your case.

Hope that helps.
Aruna.

>From: "radhika reddy" <radhika_05@hotmail.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: sqr-users@sqrug.org
>Subject: [sqr-users] currentdate - one month
>Date: Thu, 09 Sep 2004 10:30:20 -0500
>
>Hi,
>
>    I am trying to write the code in order to get one month prior to 
>current date.
>
>Thanks.
>
>_________________________________________________________________
>Don’t just search. Find. Check out the new MSN Search! 
>http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/


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