Function to Return Month from a Date

[mandy1]

Hi to all
i am Mandeep new to all of You.

i have a Problem and hope solution from you.

i want to return only Month of the Given date. suppose i have a field order_date in the order table. i want display list as follows.

Date_Result
jul
aug
dec
jan
jan
feb so on

i am using following query.
select =format(order_d ate,"mmm") AS Date_Result from orders;

this works fine and giving me required output in ms access.

but problem is i want to create a pivot table report in Excel
when i write the same query in Excel to access te Date from Ms-Access, in that case this function did not work.

so plz any one can tell me other fuction that can be used to extract only Month form the given date.

PLZ

Mandy(Mandeep)

[ADezii]

Hi to all
i am Mandeep new to all of You.

i have a Problem and hope solution from you.

i want to return only Month of the Given date. suppose i have a field order_date in the order table. i want display list as follows.

Date_Result
jul
aug
dec
jan
jan
feb so on

i am using following query.
select =format(order_d ate,"mmm") AS Date_Result from orders;

this works fine and giving me required output in ms access.

but problem is i want to create a pivot table report in Excel
when i write the same query in Excel to access te Date from Ms-Access, in that case this function did not work.

so plz any one can tell me other fuction that can be used to extract only Month form the given date.

PLZ

Mandy(Mandeep)

I'm not sure if this is what you have in mind:

1. Month(Now) will return 6.
2. MonthName(Month (Now)) will return June.

[mandy1]

I'm not sure if this is what you have in mind:

1. Month(Now) will return 6.
2. MonthName(Month (Now)) will return June.

Hi
thanks for replying.
This is working well in Access.
but again the same problem.
not work through Excel to extract data from MS-Access.

if u know any other function Plz send that one.

once again Thanks
With Regard
Mandy(Mandee)