Re: Date problem

["Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM>]

Oracle: select to_date(sysdate - 7,'dd-mon-yyyy') as SevenDaysAgo from dual

-----Original Message-----
From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM]
Sent: Thursday, May 02, 2002 9:35 AM
To: SQR-USERS@list.iex.net
Subject: Re: Date problem


Try $date_u_want = dateadd($todays_date, 'day' , -7)




-----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