Re: Forms 4.5 and times

jmw_at_vena.med.utas.edu.au (John Williams) wrote:
>Help!
>
>I am trying to store some times, in the format HH:MM, and am not having an
>easy time of it, due to some pecularities (to say the least) of Forms 4.5.
>
>The database field is specified as 'datetime'. If I set a format mask of
>HH:MM, then I can't enter high or low value ranges - putting (e.g.) 6:00 or
>06:00 gives designer error 11330 - 'value is invalid - correct format is
>hh:mm.'

This is a famous trap. MM is month, valid values are 01 ot 12. MI is minute.

Charlse Jardine,, Univ of Cambridge UK Received on Thu Jul 20 1995 - 00:00:00 CEST