Re: date format.

try to have the date in two columns of your LOV the first with the format you want to display (but not returned to you item/variable) and the real date column to return.

for your record_group
select to_char(my_date, 'DD.MM.YYYY HH24:MI' ) disp_date , my_date ...

for your LOV ddisp_date have no return item and my_date have a display width 0

"youtz" <youtz_NO_SPAM_at_hotmail.com> a écrit dans le message news: 9ie8fl$e8u$1_at_news.worldcom.ch...
> Hello,
> I have a "datetime" item and it's format mask is 'DD.MM.YYYY HH24:MI' I
 can
> enter manualy 01.07.2001 00:00, it works but if I get 01.07.2001 00:00
 from
> a List Of Values I get an error : Invalid value for field.
> (It works with the format Mask : 'DD.MM.YYYY HH24:MI:SS' and a returning
> format from the LOV as 01.07.2001 00:00:00)
>
>
>
>
Received on Wed Jul 11 2001 - 11:44:53 CEST