Re: DATETIME in Forms 6

shankaruthra_at_yahoo.com (uthra) wrote in message news:<c6fa8591.0310080821.4027dfdc_at_posting.google.com>...
> Hi,
> We are having forms 6 and i having a form which has the column as
> datetime. I need to have it as datetime for the user to put the time
> etc. And i have the format mask as MM/DD/RRRR HH:MI:SS AM. If the
> user puts the mm/dd/rrrr and leaves the field without putting the hour
> & minutes the default time 12:00AM gets registered. We don't want
> this to happen as it gives the incorrect report. Please let me know
> what is the format mask i should use in order to correct this problem.
> I also tried HH24:MI:SS. But this way the user can't choose AM/PM
> instead they have to put 21 for 9PM. Please advise.
>
> Thanks in advance

Apparently your users don't WANT to enter the time. THAT can't be resolved by changing format masks.

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 09 2003 - 09:43:05 CEST