Date/Time Field

  • Thread starter Thread starter Ayala
  • Start date Start date
A

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?
 
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).
 
Back
Top