How to get previous month name from selection box?

[#1]

Hello, I need previous month name when I select any month from Month List Box.
I don't need previous month from Today date. Lets say if I select 'May' from list box, then i must get 'April'.
Anyone? Thanks.

[#2]

Hi

try,

=Only(Month(addmonths([DATE FIELD HERE],-1)))

it depends where you're using it. you can try this in a text box^^

[amitarusi]

in the script try this:

load

datefield,

Month(makedate(year(datefield),(num(month([date]))-1),day(datefield))) as prevmonth,

month(datefield) as month,

...

...

from tablename;

In the UI when you will select month the field "prevmonth" will represent the previous month,

[#4]

Alexis, it partially solves the problem. But it returns me 3-lettered month name. How can I get full month name here? Thanks for the help though

[CELAMBARASAN · Accepted solution]

Try this

=Date(MonthStart(Max(DateField), -1), 'MMMM')

[#6]

Hi,

on your edit script

find this line

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

then change it to

Set MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

then reload.

regards,

Alex

[#7]

It worked. Thanks celambarasan.