number to date

[seat172]

Hi, i have a linked table where the date is stored as a number, can't change the format as it's an export file from an old system. The date is held thus: 20040629, for the 29th June 2004. I need to change this to a usable date to enable me to perform days since calculations. i am sort of half way there using format dateserial. But i am obviously missing something.

Any help appriciated.

Many Thanks

 

[WayneRyan]

seat,

If xxx = "20040629" then this should work.

CDate(Mid(xxx, 5, 2) & "/" & Mid(xxx, 7, 2) & "/" & Mid(xxx, 1, 4))

Wayne

 

[Mile-O]

Or:

DateSerial(Mid([Field], 1, 4), Mid([Field], 5, 2), Mid([Field], 7, 8))

 

[seat172]

Thanks guys both worked a treat, can go on holiday and relax thanks to you.