I have two date columns [ServiceStartDate] and [ServiceEndDate] in my data base. I am trying to run a query that places the date of the enquiry period [Start Date] as the [ServiceStartDate] where that date is prior to the Enquiry date [Start Date] or if the [ServiceStartDate] is equal to or after the Enquiry date then to use the [ServiceStartDate].
In Design view of the [ServiceStartDate] column, in the criteria row I have entered >=[Start Date] and in the or row I have entered IIf([ServiceStartDate]<[Start Date],[Start Date])
The problem is that it will not pickup dates entered prior to the enquiry date and only runs data entered on or after the Enquiry date.
Can anyone help?