Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to remove a value from a list box...Below is what I have but I can still select the blank value in the list box. Need to remove the value completly from the list box
List box:
1/1/2014
2/1/2014
12/31/999 (Need to remove)
=IF(termDt='12/31/9999 12:00:00 AM','',termDt)
You can try this:
=IF(termDt='12/31/9999 12:00:00 AM',null(),termDt)
or
=IF(termDt<>'12/31/9999 12:00:00 AM',termDt)
Hope it helps.
You can try this:
=IF(termDt='12/31/9999 12:00:00 AM',null(),termDt)
or
=IF(termDt<>'12/31/9999 12:00:00 AM',termDt)
Hope it helps.
=IF(Not WildMatch(termDt, '12/31/999*'),termDt)
=IF(termDt<>'12/31/9999 12:00:00 AM',termDt)