Can someone please help me out with an IIF statement - Essentially I want start date to be blank if the ending date is prior to 1/1/2017; start date to populate is start date is after 1/1/2017 and to be 1/1/17 if start date is prior to 1/1/17 and ending date is after 1/1/2017. I started out with the following and I am stuck:
=IIf([start_date]>#1/1/2017#,[start_date]," ",IIf([end_date]>#1/1/2017#,"1/1/2017"," "))
=IIf([start_date]>#1/1/2017#,[start_date]," ",IIf([end_date]>#1/1/2017#,"1/1/2017"," "))