Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
In the Load statement, I am trying to list the name of the months using my data but its showing only one month(Sep 2012) as Monthname.
Can anybody tell where I am making a mistake.
If([MONTH 01], Monthname(Today()-1),
If([MONTH 02], Monthname(Today()-2),
If([MONTH 03], Monthname(Today()-3)))) as MonthName
Regards
Chriss
Instead subtractacting days Monthname(Today()-1)
You should subtract months: Monthname(Today())-1
Hello Whiteline,
I tried what you said, but date format is coming like (31/08/2012).
Regards
Chriss
Sorry, Monthname actualy also returns full date (confused it with month()).
you should try AddMonths(Today(),-1).
Then if you want to change date format just use date() function.
Hi
try the AddMonths function:
If([MONTH 01], Monthname(AddMonths(Today(),1),
If([MONTH 02], Monthname(AddMonths(Today(),2),
If([MONTH 03], AddMonths(Monthname(Today(),-3)))) as MonthName
Hi
Assuming [Month 01] a flag value (ie values 0 or 1 or true() or false()? If so:
If ([MONTH 01], MonthName(AddMonths(Today(), -1)),
If ([MONTH 02], MonthName(AddMonths(Today(), -2))...)).
Regards
Jonathan