Search in 2 different fields
i have a question about one search i am making.
I have a table with a field "Date_1" and a field "Date_2"
I perform a search to show me all records betwen 2 dates. This search is based ONLY on the field "Date_1"
What i need is that the search would show me all records from "Date_1" AND from "Date_2"
Actually i make a search to show me all records that "Date 1" is betwen 01 and 10 July
But i have a record that "Date 1" is 20 April but "Date_2" is 03 July.
So i need my search to include this record in the results.
My Script line look like:
Set Field (MyTabe::Date_1; MyTable::S_DateBegin &"..."& MyTable::S_DateEnd)
Thank you all in advance :)