How to show date (11/08/2009) as month (August)

[Johnrg]

Guys,
I have a report that looks up a general date feild in a table.
At the moment the report reads, as an example "11/08/2009"
I want it to read "August"
or if it was 11/09/2009 the report would show "September"
Is this possible?
If so how?
Thanks
JohnG

 

[boblarson]

Guys,
I have a report that looks up a general date feild in a table.
At the moment the report reads, as an example "11/08/2009"
I want it to read "August"
or if it was 11/09/2009 the report would show "September"
Is this possible?
If so how?
Thanks
JohnG

Set the control source of your text box to

=Format([YourDateFieldInBrackets], "mmmm")

 

[Johnrg]

Thanks Bob.
JohnG

 

[Johnrg]

Hi Bob,
Just checked the report and it worked fine.
Just one thing - I see it returns formatted as "August", if there anyway to make it return in capitals formatted as "AUGUST"
Thanks
JohnG

 

[John Big Booty]

In the Format for that control put a Greater Than symbol ">", this will force it to fully capitalise,

 

[boblarson]

Hi Bob,
Just checked the report and it worked fine.
Just one thing - I see it returns formatted as "August", if there anyway to make it return in capitals formatted as "AUGUST"
Thanks
JohnG

Since you are using the format function, go ahead and do:

=UCase(Format([YourDateFieldInBrackets], "mmmm"))

 

[Johnrg]

Thanks Bob,
worked a treat!
JohnG

 

[boblarson]