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

In article <3899988A.C0953B13_at_hsv.boeing.com>, Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> writes
>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?

Have a look at $$DBDATETIME$$ and its friends in the default_value for your item.

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================