Re: Oracle Reports 2.5 - Date Formats.

In order to avoid date problems between forms & reports, I conceded to passing the date as a string value, in a predetermined format.

Then in reports, references to the date parameter are decoded with to_date(:parm_date, 'myformat')

Reports of course uses the default date format unless NLS_DATE_FORMAT is set elsewhere.

Using this practice, NLS_DATE_FORMAT can be safely ignored (except of course, for the amount of realestate it consumes on the report, unless you expressly format there also).

"Dwight" <dwight_worrell_at_hotmailNOSPAM.com> wrote:

> Try changing the format of the parameter :
> Data Model -> User Parameters, Double click your
> parameter and ensure that the datatype is Date and the
> Input Mask is DD-MON-YYYY (If this is not in the list
> you may type it in)
>
> Dwight
>
> tracey5274_at_my-dejanews.com wrote in message
> <6tisfk$h42$1_at_nnrp1.dejanews.com>...
> >Using Oracle Reports 2.5.
> >
> >Entering the following query :
> >
> >select count(ci.incident_no) Total from call_incident ci where
> >(ci.date_time_incident between upper(nvl(:P_DATE1,ci.date_time_incident))
> and
> > upper(nvl(:P_DATE2,ci.date_time_incident)) or (:P_DATE1) is
> >null or (:P_DATE2) is null)
> >
> >Within the parameter form when I enter a date in the following format
> >DD-MON-YY the search is successful, however I wish to enter a date in the
> >following format DD-MON-YYYY and so far I have not been successful, so any
> >advice would be appreciated !!!
> >
> >Thanks in advance.
> >
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>

--
joebrown
_at_leading.net