I don't see why it should be 5 characters when 4 is enough. :)
>
>I need to store time in a new field (I don't use TimeDate field yet). I don't really need to store seconds; hours and minutes is all I need. So, initially, I am thinking of making the new field 5 char long (e.g. "02:12"). But I am wondering, can someone offer a reason(s), why it might be better to create this field as 8 characters and store the seconds, even though I won't use them now. In the future update I will convert this database to a SQL Server and probably will combine another DATE field with this new TIME field into one DateTime.
>
>Thank you in advance for any input.
--sb--