Hi,
I have a field called Randomised Date and in a query I have created a field called 2 year follow-up date. In the Field in the query it says:
2 Year follow-up date: DateAdd(2yyyy, 2[Randomised Date]).
In the Criteria for this I have written <=[Enter the last due follow-up you'd like to see].
My intention was that when the query is run I can see only those who have a 2 year date before or equal to a certain date but it isn't working.
It brings up the parameter question and I enter a date but it shows me people who's date is later than that.
Any ideas what I could have done wrong?
It is doing the adding correctly just not the selection.
I have a field called Randomised Date and in a query I have created a field called 2 year follow-up date. In the Field in the query it says:
2 Year follow-up date: DateAdd(2yyyy, 2[Randomised Date]).
In the Criteria for this I have written <=[Enter the last due follow-up you'd like to see].
My intention was that when the query is run I can see only those who have a 2 year date before or equal to a certain date but it isn't working.
It brings up the parameter question and I enter a date but it shows me people who's date is later than that.
Any ideas what I could have done wrong?
It is doing the adding correctly just not the selection.