I always get crossed up on string vs. numeric too, but I believe you can do
SETVAR YESTER_MONTH !HPMONTH - 1
> -----Original Message-----
> From: Scott Gates [SMTP:[log in to unmask]]
> Sent: Friday, November 02, 2001 8:29 AM
> To: [log in to unmask]
> Subject: Handling date parms in jobs. Probably easier than I'm making
> it o ut to be.
>
> Since I don't have Maestro, I need to write something that will input
> specific dates based on the Run Date.
> For example, now it's November. I need to have my report parms be for
> last
> month.
> Since System Variables like HPYYYY seem to be Text, Can I convert to
> numeric
> and subtract 1 for the MONTH & YEAR?
> Or do I need to make a compacted !IF !ELSE IF . . . table structure?
>
> Suggestions Welcome
>
> Thanks in Advance
>
> Scott Gates
> Programmer/Analyst
> Information Services
> Our Lady of Bellefonte Hospital
> P.O. Box 789
> Ashland, Kentucky 41105-0789
> -----------------------------------
> Phone: (606)833-3773
> Fax: (606)833-3342
> -----------------------------------
> Intranet: http://Olbh01iis/intranet/index.html
> Primary e-mail : [mailto:[log in to unmask]]
> Alternate e-mail : [mailto:[log in to unmask]]
> -----------------------------------
> Our Lady of Bellefonte : http://www.olbh.com
> -----------------------------------
> Confidentiality Notice: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail, fax or phone and destroy all copies of
> the original message.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|