Access date trim

I want to trim the a date to sperate out year, month and day

                          date8                yr             month         day
for example:   20100922             2010         09      22

I have attached a spreadsheet to show what I want data to look like.
access-date.xls
mishlceAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
in a query, you can do this

select date8, left(date8,4) as yr, mid(date8,5,2) as mon, mid(date8,7) as day
from table
0
 
Dale FyeCommented:
Based on what you have provided, what you want to do is "parse" the data, not trim it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.