Need help in If statement in the Load Script

[#1]

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

[whiteline]

Instead subtractacting days Monthname(Today()-1)

You should subtract months: Monthname(Today())-1

[#3]

Hello Whiteline,

I tried what you said, but date format is coming like (31/08/2012).

Regards

Chriss

[whiteline]

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.

[gandalfgray]

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

[jonathandienst]

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