forms6 - default value for date item

[Chris Kempster]

Hi all

I havent used forms for yonks, and am having some trouble with default
values for a date item (column) for a data block. Basically the item is of
data type property "Date", ive set the format mask to DD/MM/YYYY. When I
try to enter a value for the "initial value" property I get the error:

FRM-11328 Initial value is invalid;correct format is DD/MM/YYYY

Ive tried all sorts of combo's of to_date and to_char with no luck. All I
wanted to do is put in the current system date as the default without having
to code a trigger.

ideas?

Cheers

Chris

[cf]

Add to your registry :

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
NLS_DATE_FORMAT='DD/MM/RRRR'

----------------
Christophe.

"Chris Kempster" <ckem...@iinet.com.au> a écrit dans le message news:
3b9cc3a3$0$18...@echo-01.iinet.net.au...

[Bart Wuyts]

Did you try already to put as default item value $$DATE$$, should
result in the sysdate as default in your field without writing any
code,
Success,
Bart