Convert number to date

S

SAC

I have a number field in a table that is imported from a differt system. It
stand for a date and is in the format of 20051018.

I would like to use on update query to update this to a date field.

How would I go about this?

Thanks.
 
A

Allen Browne

Use this expression in your update query:
DateSerial(Left([dt],4), Mid([dt],5,2), Right([dt],2))

Replace dt with your field name.
 
Top