title: using a variable in searchFiles Google script
body: <p>I have a third party program that pulls daily data into CSV files with the filename starting with the date it ran e.g. 17072017filename.csv
  I need a seperate spreadsheet that will take a date input from the user, which will then search through the files in drive until it matches the date on the CSV file. Once i find the file i want i can then use getFileID() and getRange() to copy various values from that CSV file.
  This is what i have at the moment (where cell A2 in the spreadsheet is where the user can type the date they want e.g. 17072017). </p>
  
  <p>Issue seems to be that i can't pass the date (which will change everyday) as a variable in searchFiles(). Is this even possible?
  This is what i have so far</p>
  
  <pre><code>function myfunction()
  {
      var inputDate = SpreadsheetApp.getActiveSheet().getRange("A2").getValue();
      var files = DriveApp.searchFiles('title contains 'inputDate'');
      while (files.hasNext()) 
      {
          var file = files.next();
          Logger.log(file.getName());
      }
  }
  </code></pre>