Converting numeric value into short date

[BBAL20]

I'm trying to convert a numeric field to a short date format. The current
value looks like "20080115". I would like to change that to 01/15/2008. Any
suggestions? I thank you in adavance for your help.

 

[BBAL20]

I was able to figure it out. Thank you for the help anyway.

 

[raskew via AccessMonster.com]

From the debug (immediate) window:

x = 20080115
y = dateserial(left(x,4), mid(x,5,2),right(x,2))
? y
1/15/2008

HTH - Bob

 

[Jeff Boyce]

Since a lot of folks look for help here, please consider posting HOW you
solved it. Someone else may face the same task and could use the helping
hand...

Regards

Jeff Boyce
Microsoft Office/Access MVP