Remove a value from a list box?

[Anonymous]

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)

[Anonymous · Accepted solution]

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.

[Anonymous]

=IF(Not WildMatch(termDt, '12/31/999*'),termDt)

[maxgro]

=IF(termDt<>'12/31/9999 12:00:00 AM',termDt)