AnsweredAssumed Answered

Search in 2 different fields

Question asked by Michelle_1 on Jul 22, 2012
Latest reply on Jul 22, 2012 by Michelle_1

Title

Search in 2 different fields

Post

Hello!

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 :)

Outcomes