thanks to all the replies.  I think I'll work with the set date parm first
and if that doesn't work I'll try some of the other suggestions.

THANKS AGAIN :)

-----Original Message-----
From: John Backus [mailto:[log in to unmask]]
Sent: Friday, January 03, 2003 10:08 AM
To: Larry Barnes
Subject: Re: MPEX date trouble


Larry,

Maybe you could borrow from this idea:

!RUN MAIN.PUB.VESOFT
SETVAR YYMMDDTODAY STRWRITE(TODAY:'%0Y%0M%0D')
SETVAR YYMMDDYESTERDAY STRWRITE(TODAY-1:'%0Y%0M%0D')
IF FEXISTS("P!YYMMDDYESTERDAY") THEN
   PURGE P!YYMMDDYESTERDAY
ENDIF
IF FEXISTS("G!YYMMDDYESTERDAY") THEN
   PURGE G!YYMMDDYESTERDAY
ENDIF
SHOWVAR YYMMDD@
!PEEKYEST
RENAME PROCDTL,P!YYMMDDYESTERDAY
RENAME GLOBDTL,G!YYMMDDYESTERDAY

John Backus
beechglen.com
(513) 922-0509




> I am trying to use a date '01/01/31' (ymd format)  and add 1 to it.  The
> problem is MPEX takes my date and converts it to mmddyy format.  How do I
> get around this?
>
> here's my test:
>
> %setlvar endate dateparse('01/01/31','YMD')
>
> %SHOWLVAR
>
> ENDATE = 01/01/31
>
> SETLVAR start_date !endate+1
>
> %showlvar
>
> ENDATE = 01/01/31
>
> START_DATE = 31/01/02
>
> * 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 *