title: How can I format a date from yyymmdd to mm/dd/yyyy using vbscript?
body: <p>Currently I have a data source that stores dates in the format yyyymmdd, and I need to return them in the format mm/dd/yyyy (there will not be a time portion to either date). I have no problem retrieving the dates from the date source, but the following is not reformatting the date (but it doesn't error either)</p>
  
  <pre><code>Set LookupDate = FormatDateTime(objRS.Fields("Date"),2)
  </code></pre>
  
  <p>Any help would be great!</p>