Month Name

[upaliwije]

Dear Friends ,

I want to show the date in my report as shown below

Business Growth Report  1-Aug

There fore I in the header section I have written following expression But It shows the month number but it does not work . pls help me

='Business Growth Report  ' & min(RISK_DAY)&'-'&monthname(max(RISK_MONTH))

[kaushiknsolanki]

What are the values of your Risk_Month field?

Regards,

Kaushik Solanki

[upaliwije]

[marcus_sommer]

You could try it in this way:

min(RISK_DAY)&'-'&date(max(RISK_DATE), 'MMM')

- Marcus

[Kushal_Chawda · Accepted solution]

try this

='Business Growth Report  ' & min(RISK_DAY)&'-'&month(MakeDate(year(Today()),max(RISK_MONTH),day(Today())))

[its_anandrjs]

Why not simply this you can try.

='Business Growth Report  ' & min(RISK_DAY)&'-'&Month(max(RISK_MONTH))

Or

='Business Growth Report  ' & min(RISK_DAY)&'-'& Date( Month(max(RISK_MONTH)), 'MMM')

[sunny_talwar]

Another option

='Business Growth Report  ' & min(RISK_DAY) &'-'& MaxString(RISK_MONTH)