Month([ArrivalDate]) not to display number month

F

Faio

Hi,

I used a query to be applied on a Date field as =Month([ArrivalDate]) and
gave me a number which stands for a Month but I do not like that and wish to
display month name.

This means that when a query date like 2/2/2004 it will returns 2 and not
Feb or February. Can this be done?

Thanks in advance
 
F

fredg

Hi,

I used a query to be applied on a Date field as =Month([ArrivalDate]) and
gave me a number which stands for a Month but I do not like that and wish to
display month name.

This means that when a query date like 2/2/2004 it will returns 2 and not
Feb or February. Can this be done?

Thanks in advance
Click to expand...
Format([ArrivalDate],"mmm")
or
Format([ArrivalDate],"mmmm")
or
MonthName(Month([ArrivalDate]))
 
L

Luiz Cláudio C. V. Rocha [MVP]

Yes,

you can use
Format([ArrivalDate], "mmm")
or
Format([ArrivalDate], "mmmm")


Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
Top