Convert numeric to date/time field 1

[charliec]

I have a dataset with a numeric field that is actually a date. The data is listed as 010828 and I need it to become a date field like 08/28/01. Any suggestions?

 

[jjonesal]

Try a calculated field like this in your query:

newdt: DateValue(Mid([dt],3,2) & "/" & Right([dt],2) & "/" & Left([dt],2))

where dt is your original field. (looks like based on your data is text, because it has a leading zero - so that's what this calculation assumes)

If you actually need to update the data in your table, you could create a new date field in the table & use an update query to update the new field using the calculation above.

J. Jones
jjones@cybrtyme.com