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.
=Only(Month(addmonths([DATE FIELD HERE],-1)))
it depends where you're using it. you can try this in a text box^^
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
=Date(MonthStart(Max(DateField), -1), 'MMMM')
It worked. Thanks Celambarasan Adhimulam.
on your edit script
find this line
then change it to
in the script try this:
Month(makedate(year(datefield),(num(month([date]))-1),day(datefield))) as prevmonth,
month(datefield) as month,
In the UI when you will select month the field "prevmonth" will represent the previous month,
Retrieving data ...