Get the month name for a value of 1-12

[BittenApple]

Hello,

I have a field in a table, the data type for this field is date/time, I have a query based on the table containing the field, I put month function to get the month of that field:
Month([ArrivalDate]) and it gave me the digit 2 because the date was 02/21/2017, so far it is correct; I wanted to get the Month name for 2 which is Feb; I used this function:
MonthName ( number, [abbreviate]), this is what I entered: New field: MonthName(Month([ArrivalDate]),True); when I get to this point, I get an error indicating data type mismatch.

What is the problem?

Regards,
orangeApple

[HansV]

Does your table contain empty (blank, null) arrival dates? That would cause a problem.

To get around it, you can use Format([ArrivalDate],"mmm")

This will return a blank if the arrival date is blank.

Or you could simply add the ArrivalDate field to the query and set the Format property of the ArrivalDate column to mmm.

[BittenApple]

Hello Hans,
I used Format([ArrivalDate],"mmm") and it didn't work, it returned all as Jan. I used IIF() and it did work.
Thanks for it.
OrangeApple

[HansV]

Format should work if ArrivalDate is a date/time field...