Why can't I search a date?

[#1]

Today is 1/16/2012.

If you search a list box of dates with =today(), you highlight today's date if it was an element of the list. 

If you search <=1/16/2012, you select all the days less than today. 

If you try <=today(), it doesn't work. 

Why and is there away around this?

[swuehl]

If your list box field is named e.g. 'Dates', try as search expression exactely as given:

=Dates<=today()

Hope this helps,

Stefan

[#3]

That works, but the reason I was asking it is because I was trying to make a button that would do that selection. For whatever reason, when I to that with a select field action button, it doesn't work.

[swuehl · Accepted solution]

Try a

='=Dates<=today()'

as search string in your button action (use the expression exactely as given, replacing Dates with your field name).