Hi all,
I am hoping someone can help as I am sure this is fairly simple but cannot seem to figure it out.
I have a "Date assessed" Section that is in my original table. In one of my queries I only want it to show data that is older than 2 years from today's date, and my other query I would like to show anything from 2 years ago until today's date.
Help would be greatly appreciated.
thank you
I am hoping someone can help as I am sure this is fairly simple but cannot seem to figure it out.
I have a "Date assessed" Section that is in my original table. In one of my queries I only want it to show data that is older than 2 years from today's date, and my other query I would like to show anything from 2 years ago until today's date.
Help would be greatly appreciated.
thank you