Re: Oracle Reports 2.5 - Date Formats.

[Quoted] 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
Received on Tue Sep 15 1998 - 04:26:10 CEST