Dates

[Jeff]

Hello. I have some columns in a table which have the
date of an event (1/6/04 format). I want to create a
query that will take the 1/6/04 date and give the
month/year in seperate columns. For example:

Test_Completed Completed_Month Completed_Year
1/6/04 January 2004

How do yo go about doing this? I am a beginner when it
comes to Access and can't figure it out. Thanks in
advance.

Jeff

 

[fredg]

Hello. I have some columns in a table which have the
date of an event (1/6/04 format). I want to create a
query that will take the 1/6/04 date and give the
month/year in seperate columns. For example:

Test_Completed Completed_Month Completed_Year
1/6/04 January 2004

How do yo go about doing this? I am a beginner when it
comes to Access and can't figure it out. Thanks in
advance.

Jeff

You can do this, but do you really need to do this in a query?

In a query, add a new column.
CompletedMonth:Format([Test_Completed],"mmmm")
Add another column.
[CompletedYear:Format([Test_Completed],"yyyy")

You can do the above just as easily in unbound control's in a report:
=format([Test_Completed],"mmmm")
=format([Test_Completed ,"yyyy")