Search behavior issue with dates.
I have added a search behavior to a set of WADB pages. The saledate field is set to = as the comparison operator.
The problem is I want to be able to search for sales on a day, but record the day and time of the sale. The field is already a day and time field. How can I use WADB to search for records recorded on a day out of a date-time field?
Is there an easy way to do thisother than setting up a between date 1 and date 2 form fields which would still have to be date time fields or if they both were the same day, it would come out 2013-03-25 00:00:00 to 2013-03-25 00:00:00.