I have 30 days listed on the form for my day results. How can I continue to 60 days on the form? After subtracting "0" and adding 30 days in test31, what would I subtract on test32? I know I can add 31 at the end. When I leave it as subtracting "0", the run says that it is too complex.
test30: IIf([DepartureDate]<=(Date()-1),0,IIf([ArrivalDate]<=(Date()-1) And [DepartureDate]>=(Date()-1),[DepartureDate]-(Date()-1),IIf((Date()-1)<=[ArrivalDate] And [ArrivalDate]<=(Date()+29) And (Date()-1)<=[DepartureDate] And [DepartureDate]<=(Date()+29),[DepartureDate]-[ArrivalDate],IIf((Date()-1)<=[ArrivalDate] And [ArrivalDate]<=(Date()+29) And [DepartureDate]>(Date()+29),(Date()+29)-[ArrivalDate],IIf([ArrivalDate]>(Date()+29),0,300)))))
test31: IIf([DepartureDate]<=(Date()-0),0,IIf([ArrivalDate]<=(Date()-0) And [DepartureDate]>=(Date()-0),[DepartureDate]-(Date()-0),IIf((Date()-0)<=[ArrivalDate] And [ArrivalDate]<=(Date()+30) And (Date()-0)<=[DepartureDate] And [DepartureDate]<=(Date()+30),[DepartureDate]-[ArrivalDate],IIf((Date()-0)<=[ArrivalDate] And [ArrivalDate]<=(Date()+30) And [DepartureDate]>(Date()+30),(Date()+30)-[ArrivalDate],IIf([ArrivalDate]>(Date()+30),0,300)))))