title: Convert date format using Altova MapForce
body: <p>Hoping that someone else out there uses Altova Mapforce for formatting dates.</p>
  
  <p>I am trying to convert the date format of my XML file. My XML file has a tag with different values like:</p>
  
  <pre><code>&lt;submitTime&gt;2016-06-09T18:27:56+0000&lt;/submitTime&gt;
  &lt;submitTime&gt;2016-06-09T18:13:10+0000&lt;/submitTime&gt;
  </code></pre>
  
  <p>I am using an XSLT stylesheet to convert the date format into form <strong>(YYYY-MM-DD)</strong></p>
  
  <pre><code> &lt;submitTime&gt;2016-06-09&lt;/submitTime&gt;
  </code></pre>
  
  <p>This is my XSLT which I have coded using Altavo Mapforce software.</p>
  
  <pre><code>.......
      &lt;submitTime&gt;
         &lt;xsl:sequence select="format-date(xs:date(fn:string(_source/submitTime)), '[y,4-4][M,2-2][D,2-2]', 'en', (), ())"/&gt;
      &lt;/submitTime&gt;
  .......
  </code></pre>
  
  <p>But when I ran this XSLT with XML using a java program, I am getting this error:</p>
  
  <pre><code>FORG0001: Invalid date "2016-06-09T17:38:20+0000" (Value includes time)
  </code></pre>
  
  <p>I am very new to this. I might be missing something. Is there any other way in Altova to convert the date into this format <strong>(YYYY-MM-DD)</strong>. Any help would be appreciated.</p>