Hi All,
I have a form that has a search function and I would like to ensure the search does not show any results where the ‘assessed date’ is over 2 years old.
I thought I put in the correct code, as it took of the results that were over 2 years old, however I have noticed now that anything new I have added is no longer showing up in the search either.
I used the code: >DateAdd("yyyy",-2,Date())
In the ‘Date assessed’ section of the Query.
When I remove this code from the query it brings up my new entries, but also brings up entries that are older than 2 years.
Please see screen shots attached of the query and the search results WITH and WITHOUT the date code.
Could someone please assist me with the correct code for this.
Thank you in advance.
I have a form that has a search function and I would like to ensure the search does not show any results where the ‘assessed date’ is over 2 years old.
I thought I put in the correct code, as it took of the results that were over 2 years old, however I have noticed now that anything new I have added is no longer showing up in the search either.
I used the code: >DateAdd("yyyy",-2,Date())
In the ‘Date assessed’ section of the Query.
When I remove this code from the query it brings up my new entries, but also brings up entries that are older than 2 years.
Please see screen shots attached of the query and the search results WITH and WITHOUT the date code.
Could someone please assist me with the correct code for this.
Thank you in advance.