title: Converting date formats in SQR
body: <p>I'm trying to convert an SQR string from the following format of <code>MM-DD-YYYY</code> into a format of <code>YYMMDD</code>.</p>
  <p>I've tried to use the following SQR function:</p>
  <p><code>STRTODATE('03-09-2018', 'YYMMDD')</code> but I get the following error.</p>
  <blockquote>
  <p>(SQR 7501) Using YY edit mask from (YYMMDD) against (03-09-2018)</p>
  <p>(SQR 1914) Bad input data (12-01-2017) for edit mask: 'YYMMDD'</p>
  </blockquote>
  <p>I think the problem is that the <code>STRTODATE</code> function is expecting the <code>YYMMDD</code> format, but the given format is in <code>MM-DD-YYYY</code>.</p>
  <p>Is there another SQR function which I can use to convert the formats?</p>
  <p>The only other approach I can think of is splitting the string into sub-strings and re-create the string, but I don't want it to become messy.</p>
  <p>This is what I'm trying to do:</p>
  <pre><code>Let $NewStr = STRTODATE('03-09-2018', 'YYMMDD')
  </code></pre>
  <p>Is there a specific SQR function which will do this for me?</p>