6781 DATE Formatting with Oracle Developer

[Quoted] I am using Oracle forms 5.

[Quoted] I am trying to accomplish the following effect.

I want my users to enter date in format MM/DD/YYYY. This I set in the format [Quoted] mask in the property palette of the text item.

However when a record is saved or updated I want to add to the date that a preset time '23:59:59'.

So if the user enters 12/19/1974, I want the database to store 12/19/1975 23:59:59

I know I can do this at the database level with insert and update trigger but [Quoted] is there anyway to do this with oracle forms.

Any ideas.

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 24 1999 - 14:41:12 CET