Re: Date problem

["Anderson, Tammy" <Anderson.Tammy@MAYO.EDU>]

Hello,

LET $OLD_DATE = DATEADD(DATENOW(),'DAY',-7)

Later,

Tammy

-----Original Message-----
From: Erik Siradas [mailto:erik_siradas@HOTMAIL.COM]
Sent: Thursday, May 02, 2002 8:22 AM
To: SQR-USERS@list.iex.net
Subject: Date problem


Hello all,

I have a problem that I hope someone out there can help me with.  I need to
make a program that gets a date in the DD-MON-YYYY format of 7 days prior
from the current date.  ie.  Today's date id 02-MAY-2002, I need to get
25-APR-2002.  Anyone have any idea how this can be done.  Thank you in
advance.

ERIK SIRADAS
PROGRAMMER/ANALYST
STATE UNIVERSITY OF NEW YORK COLLEGE AT BROCKPORT


_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com