Select in field: MAX value minus one

[Anonymous]

I need to set a list box to default to the two values after the max date. For example, see below.

I have the below expression but it does not work.

='>=' & MAX(ActiveMonth , 3)-1

[tresesco]

Format could be the issue. Try like:

='>=' & Date(MAX(ActiveMonth , 3)-1 , 'DD/MM/YYYY')

[Anonymous]

That doesn't work but the below selects all three.

='>=' & Date(MAX(ActiveMonth , 3)-1)

[m_woolf · Accepted solution]

How about:

='>=' & Date(MAX(ActiveMonth , 3)-1)&'<'&Date(MAX(ActiveMonth))