title: How do I change file name that contains a date automatically in python
body: <p>I am trying to copy data from one excel file to another automatically using python, currently i have to manually update the date in the excel file name every morning. Is there a way to automatically update the date in the excel file name. I am very new to any form of programming, trying to learn to keep my job. </p>
  
  <p>I have tried to use the time date function and declare this as a variable and copy this into code but no luck</p>
  
  <pre><code>import datetime
  
  Filedate= (datetime.date.today()-datetime.timedelta(1))
  
  exceldate= Filedate.strftime("%Y",)+Filedate.strftime("%m",)+Filedate.strftime("%d",)
  
  
  import pyexcel as p
  
  p.save_book_as(file_name="Q:\Valuations\Currency Options\YieldX Daily Statsexceldate.xls",#CHANGE DATE #manual entry. 
                 dest_file_name='YieldX Daily Stats20190522.xlsx')#CHANGE DATE manual entry
  </code></pre>