title: Rearranging the content of a cell in Cognos 10
body: <p>I've got birthdays as a varchar formatted as dd-mm-yyyy and I'm trying to build a filter that shows only the birthdates of the last 7 days.</p>
  
  <p>Now normally I'd convert that field to a date field, but since it contains dummy values this isn't an option.</p>
  
  <p>So I want to change the output to YYYYMMDD so I can use the value in a => filter.</p>
  
  <p>How can I do this?</p>