Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'd like a trigger to select every month starting from the beginning of the year to the previous month. I have a variable as previous month and a month number field. Can someone please assist. I have already made a trigger that selects the current year I only need this one to select for example if it was april select month 1,2,&3.
Thanks,
May be this string for search trigger and definition as Month-field or create 3 variables then pause those
If(Month-field = Month(Today()), '(' & Max(Month) | Max(Month)-1 | Max(Month)-2 & ')' )