title: How do I use CollectionViewSource to sort xml records by date?
body: <p>I have the following XML:</p>
  
  <pre><code>&lt;Memories&gt;
  &lt;Memory Title="blah blah" ID="1"&gt;
    &lt;ImageFile&gt;Data/Images/01.jpg&lt;/ImageFile&gt;
    &lt;Blurb&gt;We did blah&lt;/Blurb&gt;
    &lt;Date&gt;06/11/2009&lt;/Date&gt;
  &lt;/Memory&gt;
  &lt;Memory Title="Graduation" ID="2"&gt;
    &lt;ImageFile&gt;Data/Images/02.jpg&lt;/ImageFile&gt;
    &lt;Blurb&gt;We graduated!&lt;/Blurb&gt;
    &lt;Date&gt;29/11/2007&lt;/Date&gt;
  &lt;/Memory&gt;
  &lt;Memory Title="Ski time!" ID="3"&gt;
    &lt;ImageFile&gt;Data/Images/03.jpg&lt;/ImageFile&gt;
    &lt;Blurb&gt;Ski!!!!!&lt;/Blurb&gt;
    &lt;Date&gt;19/12/2008&lt;/Date&gt;
  &lt;/Memory&gt;
  //...etc
  &lt;/Memories&gt;
  </code></pre>
  
  <p>And the following XAML:</p>
  
  <pre><code>    &lt;CollectionViewSource x:Key="dataCvs" Source="{StaticResource data}" &gt;
          &lt;CollectionViewSource.SortDescriptions &gt;
              &lt;scm:SortDescription PropertyName="Date" /&gt;
          &lt;/CollectionViewSource.SortDescriptions&gt;
          &lt;CollectionViewSource.GroupDescriptions &gt;
              &lt;dat:PropertyGroupDescription PropertyName="@Name" /&gt;
          &lt;/CollectionViewSource.GroupDescriptions&gt;
      &lt;/CollectionViewSource&gt;
  </code></pre>
  
  <p>I'd like to be able to sort by date, but in its current form, the dates won't sort in natural date order; 06/11/2009 is being sorted as being before 19/12/2008 as one would expect with a program. Changing my date format to yyyy/mm/dd would cause me a problem as the XML date is being displayed as part of my form and it needs to be displayed as dd/mm/yyyy. Can anyone please enlighten me as to how I can sort the dates so suit the display requirements?</p>
  
  <p>Many thanks, I would appreciate any help.</p>