ohannis

If Statement quation

Discussion created by ohannis on Aug 7, 2013
Latest reply on Aug 8, 2013 by ohannis

Good Day guys,

what's the best way or format to construct a function that will result the following.

 

If ( DATE_FIELD ≥ DATE_FIELD_1 and DATE_FIELD ≤ DATE_FIELD_2); "Report"; "Don'r Report";

 

In human language I am trying to check if the selected date (DATE_FIELD) is within the range of DATE_FIELD_1 and DATE_FIELD_2. If it is then show result 1 or result 2.

 

It seems I cannot user and in the if statement.

 

Please help.

Outcomes