Re: How do you autopopulate a date field on a 2.1 Form?

Richard,

[Quoted] There are several ways to insert the current system date into a field. Try the following:

In the properties of the field set the default value to:

- $$DATE$$ for the current date
- $$DATETIME$$ for the current date and time
- $$TIME$$ for the current time.

[Quoted] In a trigger such as the WHEN-NEW-FORM-INSTANCE trigger: SELECT sysdate INTO :block.field
  FROM dual;

There are probably other ways but these are the methods I use.

HTH Brian.

"Richard Hollingsworth" <william.hollingsworth_at_hsv.boeing.com> wrote in message news:3899988A.C0953B13_at_hsv.boeing.com...
> Hi folks. Thanks for reading this.
>
> I have a D2K 2.1 form with a "date" field that I want to auto-populate
> with SYSDATE when the form comes up.
>
> I tried.....
>
> WHEN_NEW_ITEM_INSTANCE trigger for the date field....
>
> 1. SET CR_DATE = &SYSDATE;
>
> 2. = &SYSDATE
>
> 3. CR_DATE = &SYSDATE
>
> ............... all with, and without the "&"
>
>
> None of these worked.
>
> How do you do this?
>
>
> Thanks much,
>
> Richard Hollingsworth
Received on Thu Feb 03 2000 - 16:59:16 CET