FindMode - Does field contain date

[Matt Leach]

I have a date field in my DB for OrderDate.

I am working on a calculated search to find all records that contain an order date, no matter what the date is.

I've tried searching based on:

**/**/****

/ /

but none seem to work. How would i got about searching the field to see if a date exists?

Thanks

[comment]

*

[Matt Leach]

couldv'e sworn i did that and it yelled at me about not being in proper date format but low an behold its correct. Thanks

[comment]

Now I have a tough choice...

http://fmforums.com/forum/showtopic.php?tid/199127/post/308007/#308007