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

Brian:

Thanks much for the help. It's folks like you that make it much easier to learn this stuff!

Thanks again,

Richard H.

"Brian W. Chester" wrote:
>
> Richard,
>
> 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.
>
> 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 Fri Feb 04 2000 - 15:58:36 CET