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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Numeric Field Overflow when appending date - how to convert it to text 1
Date Conversion 4
Change a datefield to the first day in the given month? 5
Converting a numeric field to text 1
Convert 20080217 into "17-Feb-2008" , (year, month, date convertio 2
Text to Date conversion 3
Using partial dates in a query expression 6

Top