AnsweredAssumed Answered

IF Condition

Question asked by garry107 on Apr 17, 2017
Latest reply on Apr 17, 2017 by mikebeargie

Hi all,


I have been given a task of creating a report for a table.


Preview of layout 1


field 1 = yes or No (Checkbox)

field 2 = start date( drop down calender) eg: 5/22/2017

field 3 = end date( drop down calender) eg : 5/22/2022

field 4 = all the years between start date and end date ( calculation) eg: 2017,2018,2019,2020,2021,2022

and some other fields


so the report I need should be


field 1 = dropdown of +50 and -50 years. eg: 1975-2075

so if the year selected in field 1 (in the record) matches in any year in field 4 in the previous layout then i want some other fields in the respective records.


How can I achieve this.