SELECT IN FIELD

[Anonymous]

I have the below list box with a trigger for Select in Field MAX(Month)

Can I take this a step further and have the last 3 values always selected.(Data is always updating) I saw a post that uses variables for latest and previous month using variables but can this be done without using variable?

=MAX(ENDDATE_YYYYMM)

[Anonymous]

may be with Firstsortedvalue() !

[Anil_Babu_Samineni]

What's the problem with variable

From here, What you want to select

May be this?

Max(DateField,3)

[sunny_talwar · Accepted solution]

May be like this:

='>=' & MAX(ENDDATE_YYYYMM, 3)