A report contains columns New Hire ID, New Hire Name, Start Date, and Location. The organization has offices in various cities throughout the U.S. A facilities manager requests a report that includes only new hires who are located in the Atlanta and Boston offices and have a start date within 30 days of the report date.
How would you configure the filter to support this requirement?
To meet the requirement of including only new hires located in either the Atlanta or Boston offices with a start date within the next 30 days, the filter should have three conditions: Location equals Boston OR Location equals Atlanta AND Start Date equals next 30 days. This ensures that the location check is applied correctly with the OR condition, and the start date condition is combined with an AND condition to filter for those dates within the specified range.
D in my opinion; AND , OR statemets are important
a new hire's location cannot be Boston AND Atlanta, it has to be one OR the other