pull month only out of database date

D

Dennis Villareal

the database table we pull from our system is displayed as YYYYMMDD like
20081212 i would like to only show the month like 12

what do i need to do to put in the query field? it is a number field.

it is always 8 numbers.

the table field name is TAG_ACV_DT
 
D

Dennis Villareal

thanks i actually changed it to In your query, you need mid(tag_acv_dt, 1, 6)

so it shows year and month because i want to keep 2007 and 2008 of december
apart.

thanks
 

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

Pull Month from Full Date 10
How to change yyyymmdd number field to a date field 3
Date/Time to Display only Month 7
Pulling data from a linked SQL table 2
how to pull out reports for a certain month from a calculated fiel 1
query not showing all data for last month 3
Select 1st date of subsequent month based 4
Form to display current month's targets? 2

Top