Put in a msgbox to see what CLng(CDate(strDate)) is returning

"pauluk " wrote in message
...
No this is fine.

Criteria:="=" & CLng(CDate(strDate))

the "=" indicates that it has tob equal to what is placed in the input
box. i.e. less than or equals is <=

Even if i take this out or change from short integer to long on data is
shown. If i do this manually the data shows.

So help please


---
Message posted from http://www.ExcelForum.com/