Selecting month out of a date using a query?

A

Apprentice1

Could someone please help?????

I am wanting to select the month out of date using a query but i am unsure
how.

The date in the table as it stands is 20091225 and i am wanting to use the
middle 2 digits of the date but i am unsure want to use in the query to take
only those 2 digits?
 
A

Apprentice1

Thanks!

Jerry Whittle said:
TheMonth: Mid([TheDateField],5,2)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Apprentice1 said:
Could someone please help?????

I am wanting to select the month out of date using a query but i am unsure
how.

The date in the table as it stands is 20091225 and i am wanting to use the
middle 2 digits of the date but i am unsure want to use in the query to take
only those 2 digits?
Click to expand...
Click to expand...
 

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

Date serial for 2 months prior 2
Query on a calculated field 5
Excel Message box with days of month & date. 1
a query to obtain statistical info 2
Need query to filter out duplicates based on another column 4
Group by month 2
how to date records with no date 4
set a payment date of 2nd of month 4

Top