Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this formula for the report name that uses the most recent month selected as part of the report name.
nb: MonthName is just that the name of the month e.g. Nov-11, when the range July to November are selected the formula:
=
max(total MonthName) & ' YTD Customer Report'
returns "11 YTD Customer Report". I want it to say "Nov YTD Customer Report".
How do I change my formula to get the name of the month not the number
Thanks
Dave
hi, simply do like this.. set your date formate as your way.. example:
SET DateFormat='M/D/YYYY';
we have a method named, Month() . it always takes a date and retuns the month name(first 3 chars: nov) as string. so, here i have used that method and giving a parameter like '11/1/1111'. your max(total MonthName) returns 11 and i given date as 1 and year as 1111. dont bother about date and year values. it only consider the month value. try like this..
=month('max(total MonthName)&'/'&'1'&'/'&'1111') & 'YTD Customer Report'
regards
A'run'
if its not working.. try like this also =month('max(total MonthName)&/&1&/&1111') & 'YTD Customer Report'
regards
A'run'
hi Davidcoad,
If you have date field then you make it this way. So when ever the user selects the Monthname, you will get the maximum date.
MonthName(Max(Date)).
Dave
The Max function causes the numeric version of the dual to be used. This might work:
=text(max(total MonthName)) & ' YTD Customer Report'.
Hope that helps
Jonathan
hi.. deepak the monthName function returns.. monthname with year also. so, i think this is not fullfill our requirement..
plz check it once.. dont consider my reply, if am wrong..
regards
A'run'
Pls Try Following Method.
=NUM(Month(Date#(MonthName,'MMM')))