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