Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about:
='>=' & Date(MAX(ActiveMonth , 3)-1)&'<'&Date(MAX(ActiveMonth))
Format could be the issue. Try like:
='>=' & Date(MAX(ActiveMonth , 3)-1 , 'DD/MM/YYYY')
That doesn't work but the below selects all three.
='>=' & Date(MAX(ActiveMonth , 3)-1)
How about:
='>=' & Date(MAX(ActiveMonth , 3)-1)&'<'&Date(MAX(ActiveMonth))