DATETIME in Forms 6

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 Received on Wed Oct 08 2003 - 18:21:58 CEST