InfoPath Dev

Hi i have successfully used the XSLT method to create a form that when submitted sends field data to a word doc with a predefined template. I have the majority of data coming across as desired however I need to iron out a few issues.

I have 2 date fields in the form that when submitted to ms word read YYYY-MM-DD. I need the format to be DD-MMMM-YYYY ie 20-September-2009. Does any one know how to achieve this. When I look at one of the dates in the xsl file it reads as follows:

<xsl:apply-templates select="ns2:Date" />

Is there anyway of achieving what I desire here?

Cheers 

 There is most likely a way to do this.  Would you mind sharing your XSLT with us so it would be a bit easier to help?

I have attached very basic duplicate of my xslt due to privacy I cannot send the original. Thank you

<xsl:apply-templates select="ns1:Birth" />

<xsl:apply-templates select="ns1:Date" />

are the fields I am looking to have formatted 

 Thanks.  The attached file should give you an idea of how to do it.

What I did:

• Add the msxsl namespace declaration to the <xsl:stylesheet> node at the top of the file.
• Add a new template called "formatDate" near the end of the file:
      <xsl:template name="formatDate">
          <xsl:param name="date" />
          <xsl:variable name="months">
              <Month>January</Month>
              <Month>February</Month>
              <Month>March</Month>
              <Month>April</Month>
              <Month>May</Month>
              <Month>June</Month>
              <Month>July</Month>
              <Month>August</Month>
              <Month>September</Month>
              <Month>October</Month>
              <Month>November</Month>
              <Month>December</Month>
          </xsl:variable>
          <xsl:value-of select="concat(substring($date, 9, 2), '-', msxsl:node-set($months)/Month[position() = substring($date, 6, 2)], '-', substring($date, 1, 4))"/>
      </xsl:template>
• Replace <xsl:value-of select='.' /> with
              <xsl:call-template name="formatDate">
                  <xsl:with-param name="date" select="." />
              </xsl:call-template>
  in the places where my:Date and my:Birth are placed into the word formatting.

I am new to this site is there a rating system where mark you as helpful or give you some recognition for your services.

Hi Again, can you have a look at the attached file and let me know what I am doing wrong I have tried to perform the same process on this file but the date formats are not changing. I apologise I am not a programmer so I may have made an obvious mistake.

Date fields in this file are "Expiry" and "Date"

Never mind I fixed it :)

LowRyda:

I am new to this site is there a rating system where mark you as helpful or give you some recognition for your services.

 Not that I know of, but your thanks in this thread are recognition enough. :-)