title: Crystal Report Date formula to make it the end of the month
body: <p>I'm new to CR and need a formula that would give me the end of the month a on a date field.
  If the Date is 628/2012 or 7/12/2012 I need the formula to to be the end of the month no matter which day of the month the field shows. Of course we know that not every month ends on the 30th or 31th and February sometimes 29th or 30th. So what formula can I use to do this</p>
  
  <p>Example field name {table.end_date}</p>
  
  <p>Any help is greatly appreciated. </p>
  
  <p>Thanks in advance. </p>