Controls

Re: Date Format

Jimmy — Tue, 22 Sep 2009 00:14:39 GMT

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. :-)

Re: Date Format

LowRyda — Mon, 21 Sep 2009 23:45:26 GMT

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 :)

Re: Date Format

LowRyda — Mon, 21 Sep 2009 22:42:16 GMT

Jimmy you are my hero!!Works a treat. Thankyou so much!!

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

Re: Date Format

Jimmy — Mon, 21 Sep 2009 07:55:14 GMT

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.

Hopefully that will do the trick for you.

Re: Date Format

LowRyda — Mon, 21 Sep 2009 05:03:54 GMT

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

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

are the fields I am looking to have formatted

Re: Date Format

LowRyda — Mon, 21 Sep 2009 05:00:05 GMT

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

Re: Date Format

Jimmy — Mon, 21 Sep 2009 03:45:14 GMT

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?

Date Format

LowRyda — Mon, 21 Sep 2009 01:31:14 GMT

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