title: How to identify a wildcard date
body: <p>When an email from a specific sender with a specific subject comes in, my VBA code will do things with the attachment. An example of the subject line is:</p>
  
  <pre><code>Profit and Loss Summary 06-20-2014
  </code></pre>
  
  <p>Here is the code I have adapted from  <a href="http://www.jpsoftwaretech.com/outlook-vba/automate-outlook/" rel="nofollow">http://www.jpsoftwaretech.com/outlook-vba/automate-outlook/</a></p>
  
  <pre><code>Dim objNS As Outlook.NameSpace
  Set objNS = GetNamespace("MAPI")
  If TypeOf Item Is Outlook.MailItem Then
    Dim Msg As Outlook.MailItem
    Dim TwoDays As Variant
    Set Msg = Item
    If (Msg.SenderName = "My Fav Sender") And _
     (Msg.Subject = "Profit and Loss Summary"&amp; " " &amp; Format(Date, "MM_DD_YYYY")) And _
     (Msg.Attachments.Count = 1) Then
  </code></pre>
  
  <p>This recognizes today's date. I need the code to identify any date (because sometimes the reports can come in a few days later than usual, but I still want the macro to run).</p>
  
  <p>How do I use a wildcard date to this end?</p>