Conversion of Date

[Luhrern]

I have a database where dates is pesented by a 8 position text string i.e. 20020726. What kind (if any) of conversion function in Access can I use to convert this to a date i.e from 20020726 (8 position date format) to 2002.07.26 ?
Regards

Luhrern

 

[Guest_imported]

Have you tried an input mask
try
0000.00.00 in the input mask section.

 

[gol4]

?dateserial(int(left("20020726",4)),int(mid("20020726",5,2)),int(mid("20020726",7,2)))
7/26/2002

 

[gol4]

Sorry forgot to format

?format(dateserial(int(left("20020726",4)),int(mid("20020726",5,2)),int(mid("20020726",7,2))),"yyyy.mm.dd&quot
2002.07.26