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.