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

Just code an edit into the form logic and validate that the user provides the time. Depending on your circumstances you may also be able to default the field value to sysdate and just have the user overtype it when the value is different.

HTH -- Mark D Powell -- Received on Thu Oct 09 2003 - 14:58:39 CEST