convert month number to month name

[Be Borth]

I saw previous solutions to convert a month number (1) to a month name (January). I have a database with 200+ dates. In a query, I use the "Part" function DatePart("m",[full_date]), to extract the month (number) and all month extracts worked correctly (they returned the correct numerical month). However, when I attempted adding a field in the query to format that extracted month to a month name, it only returned January and December - for all 200+ records. What did I do wrong and how can I correctly get the month name to appear.

thanks

[ajalwaysus]

Be Borth,

You need to show us what you did, not just tell us, so that we can review it and offer up a possible solution.

-AJ

[Be Borth]

Thanks AJ - I'm happy to do that, but the database contains a lot of personal information (names, birthdates, etc) that I would be uncomfortable posting on a public website. Any suggestions?
ben

[ajalwaysus]

All I need to see is the function you are using to convert the date. Perhaps your DatePart function along with whatever you are using to convert the DatePart to a date name. Just copied and pasted into the thread, also note, please use the [code] brackets when posting code.

-AJ

[missinglinq]

Format([full_date],"mmmm") should do it for you.

Welcome to Bytes!

Linq ;0)>

[Be Borth]

Ok, AJ, thanks. The datafile has a field "full_date" which might be 1/8/1953 for example. In the query, I used the DatePart function to extract the month number in the following way [event_date_month: DatePart("m",[full_date])]. This successfully returns the correct numerical value for the months. However, when I try to create a new field in the query to convert that value to a month name using the Format function I only get "December" or "January". The same thing happens if I try to change the format of "event_date_month" in the query or the report using the properties drop-down menu

[ajalwaysus]

Let me know if missinglinq's code works for what you are doing.

-AJ

[Be Borth]

thanks Linq - I've seen that response before and I'm not sure where to put that code. Do I create a new field or where exactly do I embed the code Format([full_date],"mmmm") in the query? Sorry for being kinda slow on the uptake

[ajalwaysus]

Without a good idea of your code structure I would say simply replace your

DatePart("m",[full_date])

with

Format([full_date],"mmmm")

wherever you have it in your code.

-AJ

[Be Borth]

It works! Thanks AJ, and thanks Linq!!

[ahmedtharwat19]

we can use this code

monthname(datepart("m",[full_date]))
 

[twinnyfo]

ahmedtharwat19,

First, this is a five year old thread, so the OP probably has lost oversight of this question long ago.

Second, ajalwaysus' answer in Post #9, not only was selected as a correct answer, but is actually the "best" answer, as your solution causes the system to utilize two functions rather than just one. one iteration may only take a few milliseconds longer, but if there were millions of dates to transpose, your solution would take approximately twice as long.

[Loyno18]

@ahmedtharwat19
Ahmed,

Thank you very much