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
