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.