I have a form with unbounded text boxes for searching purposes. A couple of these are date fields (where I check to see if certain records fall between a date range). How do I make it so that my query ignores the fact that they may be blank unbounded text boxes? I know the typical trick to get around this issue with regular text is to use the LIKE function, but for dates the same approach doesn't work.
Any help is appreciated.
Thanks!