Unanswered: Forecasting dates in designview (ACCESS 2000)
I have created a table in which I want my query to meet two criteria to be true. I want the query to forecast 30 days out from today's date searching only one (date) field and if a second field Is Null the statement is true. (Both have to be met to be true) I have the second part working but am having difficulty with the first part. This is what I have:
Condition1: IIf(Date() Between [NEXT PERFORMANCE REPORT] And DateAdd("d",30,[NEXT PERFORMANCE REPORT]) And [date rcvd] Is Null,False)
I have been working on this for days and any assistance would be greatly appreciated.
Contacted a friend back in the States and together we determined the statement was incorrect and that it was adding 30 days to the [next report date] versus Date(). Also reset the date() format in in regional settings.
Condition1: IIf([NEXT PERFORMANCE REPORT]between Date() And DateAdd("d",30,Date()) And [date rcvd] Is Null,True,False)