[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Date problem

Try this if u r using oracle:

 select to_char(add_months(sysdate, -7), 'DD-MON-YYYY') from dual;


-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@LIST.IEX.NET]On Behalf Of Erik Siradas
Sent: Thursday, May 02, 2002 9: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