Date Values

S

SageOne

I have built a small application that a customer service dept uses to keep
track of records. I have a form set up with a bunch of fields one of which is
a date field. When I review the table that the forms dumps into, it seems all
of my dates have been saved as text. But when I double click on the date
field, it moves to the right side of the cell and appears to now be formatted
as text.

How can I set up my date field in my form, so when someone types in a date
it is automatically stored in the corresponding table in a date format that
could be sorted as such.
 
J

John W. Vinson

I have built a small application that a customer service dept uses to keep
track of records. I have a form set up with a bunch of fields one of which is
a date field. When I review the table that the forms dumps into, it seems all
of my dates have been saved as text. But when I double click on the date
field, it moves to the right side of the cell and appears to now be formatted
as text.

How can I set up my date field in my form, so when someone types in a date
it is automatically stored in the corresponding table in a date format that
could be sorted as such.
Click to expand...

You're talking about "cells" which suggests that you're using Excel not
Access... is that correct?

If you are in Access, open the Table in design view and select this field.
Make sure that its datatype (the second column in the table design grid) is
Date/Time.
 
Top