Date/Time Field

[Ayala]

I need a day time field which also accepts text.
I need to force the entry to this format: Ex.
08.08.2003/11.30 Swiss Time
21.10.2003/21.00 Mexico Time.

How can do this?? or the only solution is to use two
fields?

 

[Douglas J. Steele]

A date/time field cannot accept text. That's because a date/time field is
actually an 8 byte floating point number (the date is stored as the number
of days relative to 30 Dec, 1899, and the time is stored as a fraction of a
day).

Your only options are to store a date/time and a text field, or store the
entire thing in a text field (which would certainly limit what calculations
you'd be able to do).