Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a button that would select the last week of information using select in field with a field of Week and a search string of
=(Week(today(1))-1)
I also created a button to select the current year using select in field with a fiend of Year and a search string of
=(Year(today(1)))
I also tested it to select last year using a search string of =(Year(today(1))-1)
However using the same format to select last month doesn't work.
Using Month as the field and a search string of =(Month(today(1))-1) it selects nothing.
If I use =(Month(today(1))) I get the current month (as I do if I replace the 1 with a 0 or -1)
How do I make this button select last month?
Thanks all.
Hi,
=Month(AddMonths(Today(), -1))
Aurélien
Try below expression
=Month(Today()-1)
Hi,
=Month(AddMonths(Today(), -1))
Aurélien
Are you sure, above all working? If yes, month should work. Can you please share the application where do you applying this. We can have a look
Thank you Aurelian.
This is the solution I needed. Works perfectly.
Thank you.
I have the similar requirement, but my Month filter is in diff format like YYYY-MM and I want to select last month every time.
my month filter name is GasMonth. =Month(AddMonths(Today(), -1)) this is not working in my case, please help me.