title: Converting string to date in Crystal Reports
body: <p>I'm new to Crystal Reports, I'm trying to extract and display month and year from the string (In DB the data type of the column is varchar). Following is an example of the data.</p>
  
  <blockquote>
    <p>05-JAN-12 11.49.28.000000000 AM</p>
  </blockquote>
  
  <p>I need it in following format</p>
  
  <blockquote>
    <p>Jan-12</p>
  </blockquote>
  
  <p>I have used <a href="http://pic.dhe.ibm.com/infocenter/rsawshlp/v7r5m0/index.jsp?topic=/com.businessobjects.integration.eclipse.designer.doc/html/topic728.html" rel="nofollow noreferrer">cDate</a> to convert the string to date format but was unsuccessful, maybe I didn't do it right way.</p>