<i>Answer from CompleteITProfessional :</i>
Depending on how your data is structured, you’ll need a query similar to this:
WHERE datefield > SYSDATE – (365 * 10)
If you’re after more information on the financial years, you may need to convert the dates to financial years and go back 10 in the past.
It’s a generic query that I’ve provided but I hope it helps!