title: convert ddmmyy date into prompt in universe SAP BO
body: <p>I need to display last 2 years of data based on the what date the user enters: </p>
  
  <p>If the user enters 01/01/2015, I need to see data from 01/01/2013 to 01/01/2015 </p>
  
  <p>The date will be entered in dd/mm/yy (datetime) format. </p>
  
  <p>How do I achieve this in Webi? </p>
  
  <p>I tried the below code in my universe level filter </p>
  
  <p>DIM_GROUP_CONTRACT.GRP_CONTRACT_EFFECTIVE_DATE between TO_NUMBER(TO_CHAR(trunc(To_date(@Prompt('Select Reporting End Month: ','A','Record Effective Date\Record Effective Month',mono,free,persistent)||'01','YYYYMMDD'),-24),'MM'), 'YYYYMM')) </p>
  
  <p>and TO_NUMBER(TO_CHAR(trunc(Add_Months(To_date(@Prompt('Select Reporting End Month: ','A','Record Effective Date\Record Effective Month',mono,free,persistent)||'01','YYYYMMDD'),'MM'), 'YYYYMM')) </p>
  
  <p>it gives me error </p>
  
  <p>The requirement is to add date in dd/mm/yy format</p>