sql*forms, format mask, date field

You should be using datetime fields in forms 3 to do this sort of processing.

Note that if you use a time only mask then a date in 1988 will be stored however this will not be problem if you only do time comparisons.

As for the AM/PM I cannot comment as being European I use 24 hours ;-)*

--
frozzboz_at_zork.demon.co.uk  (Keith Davidson)

Watch out The Borg are about