Oracle Reports 2.5 - Date Formats.

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 [Quoted] 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 Mon Sep 14 1998 - 12:51:32 CEST