forms6 - default value for date item
From: Chris Kempster <ckempste_at_iinet.com.au>
Date: Mon, 10 Sep 2001 21:47:22 +0800
Message-ID: <3b9cc3a3$0$18348_at_echo-01.iinet.net.au>
[Quoted] Hi all
Date: Mon, 10 Sep 2001 21:47:22 +0800
Message-ID: <3b9cc3a3$0$18348_at_echo-01.iinet.net.au>
[Quoted] 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 [Quoted] 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 [Quoted] to code a trigger.
ideas?
Cheers
Chris Received on Mon Sep 10 2001 - 15:47:22 CEST
