Converting numeric value into short date

B

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.
 
R

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
 
J

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
 
Top