title: Filtering between two dates in pivot table using VBA. UK to US date format issue
body: <p>I have found a workaround for this but if anyone has a cleaner way of doing this I'd be interested/grateful.</p>
  
  <p>I have two boxes on a spreadsheet, called DateFrom and DateTo for use with a Date filter in a pivot table. Both are in the format DD/MM/YYYY. The data feeding into the table is also in this format. The pivot table also returns the dates in the same format. All my settings are in English UK and I've tried this on a separate machine with the same results.</p>
  
  <p>I then use the following code to feed into the pivot table:</p>
  
  <pre><code>ActiveSheet.PivotTables("Pivot").PivotFields("Date").PivotFilters. _
      Add Type:=xlDateBetween, Value1:=Range("DateFrom").Value, Value2:=Range("DateTo").Value
  </code></pre>
  
  <p>The code reads the two cells as string and then applies this to the pivot table as if they were US format (MM/DD/YYYY). Ridiculous!</p>
  
  <p>This is how I got around it:</p>
  
  <p>I had two more cells looking at these two cells in numeric format and aimed the code at these two cells instead. Not sure about any of you but I would struggle to convert any date into numeric in my head...!</p>
  
  <p>If you have a simplified solution and/or explanation to this utter craziness I'd be much obliged!</p>