1 Reply Latest reply on Sep 20, 2013 12:47 PM by Charley Saint

    SQL query for files created today

    Shankaran Shanmugabaskaran
    Shankaran Shanmugabaskaran Sep 20, 2013 8:10 AM

           I need a sql query that shows files created today, is that possible?

      • 1077 Views
      • Tags:
        • Re: SQL query for files created today
          Charley Saint
          Charley Saint Sep 20, 2013 12:47 PM (in response to Shankaran Shanmugabaskaran)

          Shankaran,

           

          Play around with this, there are a lot of different dates in the revisions table to try:

           

          select Path + filename, r.Date from

          Documents d

          inner join DocumentsInProjects dp on d.DocumentID = dp.DocumentID

          inner join Projects p on p.ProjectID = dp.ProjectID

          inner join Revisions r on r.DocumentID = d.DocumentID and r.RevNr = 1

          where DATEDIFF(HOUR, r.Date, GETUTCDATE()) < 24