Xref: alice comp.databases.oracle.tools:14217 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!feed2.news.erols.com!erols!not-for-mail From: "Peter H. Larsen" Newsgroups: comp.databases.oracle.tools Subject: Re: Reports 1.x - &date variable Date: Tue, 07 Jul 1998 15:23:43 -0400 Organization: Dynamic Resources Inc. Lines: 44 Message-ID: <35A275BF.A9F2F7C8@dc.dynares.com> References: <1998Jun30.123205@admin1.tcd.ie> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: winter.news.erols.com 899839526 17251 207.96.14.31 (7 Jul 1998 19:25:26 GMT) X-Complaints-To: abuse@erols.com X-Mailer: Mozilla 4.05 [en] (Win95; I) To: mcgrathm@admin1.tcd.ie Hi, You have several options ... One is .. as far as I remember, date is part of the parameters. So just change the formatting there. Another option is, to add a field DATE (if not accepted then choose another name and change the reference in the text editor) to report level, let the source be &SQL SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY') INTO :DATE FROM SYS.DUAL and the type is CHAR lenght 10. That's the simplest way of doing it. Usually I had a master SQL where all parameters and header titles were selected and formatted - I would never use the default & parameters. So changing Y2K would be pretty easy if your programs follewed the same rules. Hope this helps ... Peter H. Larsen Oracle Consultant mcgrathm@admin1.tcd.ie wrote: > > Hi, > > I am doing some y2k work on reportwriter 1.1 reports and would > like the &date report defined variable to appear as a 4 digit year without > having to define a sysdate variable in the report select. > > Please can anyone suggest a quick fix to format the &date in the > DD/MON/YYYY rather than the current DD/MON/YY. > > TIA, > > Michael -- Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria Phone: 703-914-9800 #103 Fax: 703-914-9804 Email: plarsen@dc.dynares.com (please remove the nospam from the header when replying to this email) The above views are my own and does not reflect the views of my employer.