MonthName Function 1

[epoh]

How can I convert the @Beginning_Date (Report Parameter) to a MonthName

I tried the following:

[COLOR=blue]
"Document Name: " & chr(34) & "Test" & chr(34) & " Document Note: " & chr(34) & 
MonthName({@Beginning_Date},True) & ", " & Year({?@Beginning_Date}) & chr(34)
[/color]

that wont work because "@Beginning_Date" is not a number.

As you can see the date format I am trying to display is

Month, Year
Oct, 2006

How can this be achieved?

 

[Kendel]

You can try to convert @Beginning_Date to number see if it will work for you:
MonthName(ToNumber({@Beginning_Date}),True)

 

[BobSuruncle]

Try this:

"Document Name: " & chr(34) & "Test" & chr(34) & " Document Note: " & chr(34) & 
CStr({@Beginning_Date},"MMM") & ", " & CStr({@Beginning_Date},"yyyy") & chr(34)

Bob Suruncle

 

[epoh]

Thanks, Bob. That worked. That is exactly what I needed.