Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make Month Name out of String parameter

Status
Not open for further replies.

veronic

Programmer
Apr 6, 2004
73
US
I have string parameter ClosedDate (for example : user enter 07/30/2004) and I need it as a string(not date).
Is it possible to put corresponding month name on the title of the report?
If user select 7/30/2004 then on the title: for July, 2004...
 
make a formula
cdate(fieldname)
put the formula on the report footer

Right click on it, select format tab and adjust the date format that you want to display

Regards
Emre
 
Try this:

MonthName(Month(CDate({?StringDate}))) + ", " + ToText(Year(CDate({?StringDate})), 0, "")

-dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top