title: How to validate date field with format MMM/DD/YY or MMM/DD/YYYY?
body: <p>My field contains the string values like JUL/11/2017, JAN/11/17. Though it is a valid field, i am not able to validate it using is_date function</p>
  
  <pre><code>SET DATEFORMAT MDY;  
  if isdate('JUL/11/2017')=1
  print 'VALID_DATE'
  else
  print 'invalid date'
  </code></pre>
  
  <p>If the field value is DD/MMM/YY or DD/MMM/YYYY , it works fine. Any one can help me validating this field. </p>
  
  <p>Note:I have tried using set language option too.</p>