need function help

[foolishone]

I need some help on changeing the properties of a field which is called "DateJoined" but was imported into table with this format 20011909. Can someone help me with an access function or expression to get the result 2001/19/09 on my form.

Thank you, ken

 

[shacket]

In the Input Mask of the control on the form, put the following:

####"/"##"/"##

 

[Pat Hartman]

It would be much better in the long run to store the date as a date/time data type. You can either do the conversion again with an import spec that specifies the date format so that Access can interpret it properly or you can add a new column to the table and run an update query to convert the text string to a date. Once the text string has been converted to a date, you can delete the text string column.

 

[foolishone]

Thank You very much it worked just fine

ken