Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Finding a year in a date field

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  Problem with windows Xp help and support  
Author Message
Bob

External


Since: Dec 10, 2008
Posts: 11



(Msg. 1) Posted: Tue May 26, 2009 1:14 pm
Post subject: Finding a year in a date field
Archived from groups: microsoft>public>access (more info?)
I need to pull all records for 2008 in a date field called completed. I know
this shoudl be easy but I can never seem to find any help on date fields that
seems to relate. I just want to create a simple query.

 >> Stay informed about: Finding a year in a date field 
Back to top
Login to vote
Ken Snell [MVP]

External


Since: May 26, 2009
Posts: 1



(Msg. 2) Posted: Tue May 26, 2009 4:21 pm
Post subject: Re: Finding a year in a date field
Archived from groups: per prev. post (more info?)
SELECT *
FROM TableName
WHERE Year(DateFieldName) = 2008;

 >> Stay informed about: Finding a year in a date field 
Back to top
Login to vote
Bob

External


Since: Dec 10, 2008
Posts: 11



(Msg. 3) Posted: Tue May 26, 2009 4:21 pm
Post subject: Re: Finding a year in a date field
Archived from groups: per prev. post (more info?)
As allways Ken I appreciate the quick response and accurate suggestion.
Works great.

"Ken Snell [MVP]" wrote:

> SELECT *
> FROM TableName
> WHERE Year(DateFieldName) = 2008;
>
> --
>
> Ken Snell
> wrote in message
>
> >I need to pull all records for 2008 in a date field called completed. I
> >know
> > this shoudl be easy but I can never seem to find any help on date fields
> > that
> > seems to relate. I just want to create a simple query.
>
>
>
 >> Stay informed about: Finding a year in a date field 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
date format - excluding year - Hello again - I'm having trouble entering dates without the year. I want to keep the year in a separate column (so I can sort or filter by year). I know I should be able to format it using dd-mmm, but as soon as I export it to Excel, 2009 is ..

MM/DD date format no year - Hi, Is there a way to format the input for a date field using only the month and day. I have a program where I input data for a given year and don't want to enter the year with every date input. Thanks,

Automate Change of the format of a field to short date for.. - Hi, I have a table that I am creating through a make table query. Once created, I want to export the table to a text file and save to a location. I am attempting to create a macro that will do this. One of my fields is called CMMonth. The problem i...

Access 2003 Conversion Toolkit not finding 97 databases - I'm running the Access Conversion Report Tool (gui) but it isn't finding any databases! I have 2003 installed on the C drive and 97 on the D drive. Any ideas what I'm doing wrong?

Query/Report how many items ordered over the year - I have created a report that shows how many items were ordered over the course of one year for xyz products. I would like to enhance the query but my skills are pretty limited so I am seeking some help. I would like my query to display results..
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]