Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Over a field Fecha.
=MonthName(AddMonths(MonthName(Max(Fecha)),-1))
Try like:
MonthName( SelectedDatefield, -1)
Probably you need convert to date
=MonthName(AddMonths(MonthName(GetFieldSelections(FieldName)),-1))
=MonthName([MonthName(Date)]-1)
thanks a lot.. it worked