ValueList & Find

[mikeap]

Result Set:
2007-04-03 06:05:00.0, 2007-04-03 06:05:00.0

So as you can see in the attached code I'm trying to find the character "-" in my valueList, which it should as you can see in the above result set. It's not finding it though. What am I doing wrong?

[mikeap · Accepted solution]

I used COALESCE on my date field to put a default value if NULL. Then I searched for that default value in my Find statement and whalla ... works!