Re: Question

Hi Katie,

One way to do that is to use a form trigger. Before entering the block or the form, a trigger can be triggered and it can do the job.

I know the t you can also do the same using the porperty list.

The McCrays wrote:

> I posted a question yesterday, but I need to revise it a little.
>
> I'm working on a college project, and can't find the answer to this anywhere
> in my text, so I apologize for such a basic question!!
>
> When the data entry person opens a particular form, I need a date field to
> be automatically set for the system date + 2 months, but in addition the day
> needs to always be set to the 1st of that month. So, if todays date is
> April, 28,2001, the date field should read June, 1, 2001.
>
> I currently am using add_months(sysdate,2) as the formula for the attribute.
> Now, what do I add to set the day to 1?
>
> Thanks again for any help.
>
> Katie
  Received on Sun Apr 29 2001 - 14:14:48 CEST