Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert numeric to date/time field 1
- Thread starter charliec
- Start date
-
1
- #2
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
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
- Status
Similar threads
- Question
