How can I get the attachment version number at a given point of time ?

Question

for example: AttchmentA has versions: 1. from Jan 9,  2. from Jan 12,  3. from Jan 16. 4. from Jan 19.
I now want to know the actual Version at a given date "Jan 14" for example?  (answer here would be version=2, because at January 14 this is the actual version)
Access then should be included into a reporting-generator.

Thanks and best regards, Clemens.

m_2mnasz · Accepted Answer

You could query the Confluence database.  Here is an article from 2010 but the concepts are sound:

http://www.divingintothedetails.com/confluence/use-sql-to-quickly-get-information-out-of-confluence/