MonthYear -1

[Muthu]

Hi,

I have a requirement where I have to take MonthName of a particular value -1

Eg : if Its Sep - 2014 it has to be Aug - 2014

I have used the following expression But its not working,

Please help.

=AddMonths(GetFieldSelections(FieldName),-1)

[ecolomer]

Over a field Fecha.

=MonthName(AddMonths(MonthName(Max(Fecha)),-1))

[tresB]

Try like:

MonthName( SelectedDatefield, -1)

[ecolomer]

Probably you need convert to date

=MonthName(AddMonths(MonthName(GetFieldSelections(FieldName)),-1))

[tyagishaila]

=MonthName([MonthName(Date)]-1)

[Muthu]

thanks a lot.. it worked