Month([ArrivalDate]) not to display number month

[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

 

[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

Format([ArrivalDate],"mmm")
or
Format([ArrivalDate],"mmmm")
or
MonthName(Month([ArrivalDate]))

 

[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