Re: Reports 1.x - &date variable

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