Current Year and Last month selection

[#1]

Hello Friends,

I want the current year selection in callender and previous month selection.

So can any one tell me how to do this, as I have done for current year through sheet properties trigger but what about previous month selection how to give previous month selection.

Thanks,

Ashish

[crusader_ · Accepted solution]

Hi,

Use below expression in search string:

=Month(AddMonths(today(),-1))

EDIT: Add new trigger to your existing Year selection which will select in field Month within above SearchString.

Regards,

Andrei

[Marcellino_Groothof]

Hi,

Write in the script:

LET CY = year(today());

LET CM = month(today())-1;

then in a expressie: sum ({$<year={$(CY)},month={$(CM)},>} amount)

Regards

[kavita25]

Try the below expression for previous Month trigger.

Sheet properties >> On Activate Sheet >> Selection >> Select in Field >> Field- Date Field >> Search String

month(MonthStart(Max(Date_Field),-1))

[#5]

Thank you, Kavita and Marcellino for your response but its not working with your exp.

n the correct ans is

=Month(AddMonths(today(),-1))

[#6]

Thank you very much Andrei, for your response. its working with your exp.

[kavita25]

My expression was based on date field..

If you have date field and use the expression given by me, will surely work...

[#8]

Ok sure...Thanx....