XML dates

adam bob · Sep 19, 2007

Hello, i'm currently working on some xslt that formats some xml gained
from an infopath form. The problem i have is the date. Basically its
generatng the date in this format; 2007-09-04 00:00:00. Ideally i'd
like the date to be in the following format; 12-aug-2007, or
14/07/2007 etc.

I've tried applying numerous templates etc gained from the internet,
but none of them seem to work, or contain errors so my xslt doesnt
parse.

the code;

____________________________________________________________________________________________

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/
myXSD/2007-01-25T08:56:14">
<xsl

utput method="html"/>
<xsl:template match="/">

<html>



<style type="test/css">
#style1
{
}

</style>

<body>

IT project test


 
 

<table style="width: 100%">
<tr>
<td>




<xsl:value-of select="my:myFields/
my

roject_name"/>

 
 

<xsl:value-of select="my:myFields/
my

riority"/>

 
 

<xsl:value-of select="my:myFields/
my

roject_sponsor"/>

 
 

<xsl:value-of select="my:myFields/
my

roject_owner"/>

 
 

<xsl:value-of select="my:myFields/
my

roject_category"/>

 
 

<xsl:value-of select="my:myFields/
my:start_date"/>

 
 

<xsl:value-of select="my:myFields/
my:est_finish"/>



</td>
</tr>

</table>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

____________________________________________________________________________________________

Please help!!

Many thanks

Adam

Martin Honnen · Sep 19, 2007

adam said:
Hello, i'm currently working on some xslt that formats some xml gained
from an infopath form. The problem i have is the date. Basically its
generatng the date in this format; 2007-09-04 00:00:00. Ideally i'd
like the date to be in the following format; 12-aug-2007, or
14/07/2007 etc.

I am not sure which XSLT processor infopath uses but it might be MSXML
5. With MSXML you have extension functions to format dates and times
e.g. this stylesheet

<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0"
xmlns:ms="urn:schemas-microsoft-com:xslt"
exclude-result-prefixes="ms">

<xsl:template match="/">
<example><xsl:value-of select="ms:format-date('2007-09-04',
'dd-MMM-yyyy', 'en-US')"/></example>
</xsl:template>

</xsl:stylesheet>

outputs

<example>04-Sep-2007</example>

See the documentation of MSXML in the MSXML SDK:
<URL:http://msdn2.microsoft.com/en-us/library/ms763742.aspx> and the
section about format-date:
<URL:http://msdn2.microsoft.com/en-us/library/ms256099.aspx>

adam bob · Sep 20, 2007

Hello, i'm currently working on some xslt that formats some xml gained
from an infopath form. The problem i have is the date. Basically its
generatng the date in this format; 2007-09-04 00:00:00. Ideally i'd
like the date to be in the following format; 12-aug-2007, or
14/07/2007 etc.

I've tried applying numerous templates etc gained from the internet,
but none of them seem to work, or contain errors so my xslt doesnt
parse.

the code;

____________________________________________________________________________________________

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/
myXSD/2007-01-25T08:56:14">
<xslutput method="html"/>
<xsl:template match="/">

<html>



<style type="test/css">
#style1
{
}

</style>

<body>

IT project test


 
 

<table style="width: 100%">
<tr>
<td>




<xsl:value-of select="my:myFields/
myroject_name"/>

 
 

<xsl:value-of select="my:myFields/
myriority"/>

 
 

<xsl:value-of select="my:myFields/
myroject_sponsor"/>

 
 

<xsl:value-of select="my:myFields/
myroject_owner"/>

 
 

<xsl:value-of select="my:myFields/
myroject_category"/>

 
 

<xsl:value-of select="my:myFields/
my:start_date"/>

 
 

<xsl:value-of select="my:myFields/
my:est_finish"/>



</td>
</tr>

</table>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

____________________________________________________________________________________________

Please help!!

Many thanks

Adam

I've tried this but i still get errors. My xslt is gaining the data
from an external xml document generated by an infopath form. So the
date defaults to this format. So i need a way of manipulating the date
captured in order to display like dd/mm/yyyy. I guess i have to use
some kind of template, but i've tried adding some from the internet,
but they contain errors like ' template cannot be a child of body tag,
or font tag etc etc. I've tried removing these tags up until the point
there is bearly any code left.

______________________________________________________________________________________________________________________________________

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/
myXSD/2007-01-25T08:56:14">
<xsl

utput method="html"/>
<xsl:template match="/">

<html>

<head>



<style type="text/css">
.style1
{
font-family: Arial, Verdana, Helvetica, Sans-serif;
font-size: 16px;
color: #003399;
font-weight: bold;
}
.style2
{
font-weight: bold;
}
</style>

</head>

<body>

 

Project Dates

 
 

<table style="width: 100%">
<tr>
<td>




Start
date: <xsl:value-of select="my:myFields/my:start_date"/>

<xsl:template name="standard_date">
<xsl

aram name="date" />

<xsl:value-of select="substring($date,
7, 2)" />
<xsl:text>/</xsl:text>

<xsl:value-of select="substring($date,
5, 2)" />
<xsl:text>/</xsl:text>

<xsl:value-of select="substring($date,
3, 2)" />
</xsl:template>

 
 

Estimated
Finish Date: <xsl:value-of select="my:myFields/my:est_finish"/>

 
 

Project
Duration: <xsl:value-of select="/my:myFields/my:group1/
my:difference"/>



</td>
</tr>

</table>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

_____________________________________________________________________________________________________________________________________

Here i've added a template. Maybe i have to re-format the structure?

thanks

Adam

Ben · Sep 20, 2007

I've tried this but i still get errors. My xslt is gaining the data
from an external xml document generated by an infopath form. So the
date defaults to this format. So i need a way of manipulating the date
captured in order to display like dd/mm/yyyy. I guess i have to use
some kind of template, but i've tried adding some from the internet,
but they contain errors like ' template cannot be a child of body tag,
or font tag etc etc. I've tried removing these tags up until the point
there is bearly any code left.

______________________________________________________________________________________________________________________________________

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/
myXSD/2007-01-25T08:56:14">
<xslutput method="html"/>
<xsl:template match="/">

<html>

<head>



<style type="text/css">
.style1
{
font-family: Arial, Verdana, Helvetica, Sans-serif;
font-size: 16px;
color: #003399;
font-weight: bold;
}
.style2
{
font-weight: bold;
}
</style>

</head>

<body>

 

Project Dates

 
 

<table style="width: 100%">
<tr>
<td>




Start
date: <xsl:value-of select="my:myFields/my:start_date"/>

<xsl:template name="standard_date">
<xslaram name="date" />

<xsl:value-of select="substring($date,
7, 2)" />
<xsl:text>/</xsl:text>

<xsl:value-of select="substring($date,
5, 2)" />
<xsl:text>/</xsl:text>

<xsl:value-of select="substring($date,
3, 2)" />
</xsl:template>

 
 

Estimated
Finish Date: <xsl:value-of select="my:myFields/my:est_finish"/>

 
 

Project
Duration: <xsl:value-of select="/my:myFields/my:group1/
my:difference"/>



</td>
</tr>

</table>

</body>
</html>

</xsl:template>
</xsl:stylesheet>

_____________________________________________________________________________________________________________________________________

Here i've added a template. Maybe i have to re-format the structure?

thanks

Adam- Hide quoted text -

- Show quoted text -

Hello there bob?

it sounds like what youre looking for is a substring operator to cut
that datetime down

heres a usefull link that might help

http://articles.techrepublic.com.com/5100-22-1054414.html

regards

Ben

adam bob · Sep 20, 2007

Hello there bob?
Isnt there a specific way of formatting dates in xslt?

Nicolas George · Sep 20, 2007

adam bob wrote in message

Hello, i'm currently working on some xslt that formats some xml gained
from an infopath form. The problem i have is the date. Basically its
generatng the date in this format; 2007-09-04 00:00:00. Ideally i'd
like the date to be in the following format; 12-aug-2007, or
14/07/2007 etc.

In terms of logic and usability, "2007-09-04" is better than "14/07/2007"
(because the digits are in weight order), which is better than "12-aug-2007"
(because it requires a table lookup).

And please, do not forget to include a time zone in your time format.

Joe Kesselman · Sep 21, 2007

Personally, I would recommend that dates in XML be expressed in a format
compatible with that of the XML Schema date/time datatypes, since that
gives you the best odds that off-the-shelf tools will be able to help
you manipulate them (in the future, if not now).

Help with code	0	Jun 12, 2022
Help with my responsive home page	2	Dec 14, 2022
Need help , Having problem with Drag n Drop...	1	Dec 21, 2022
XSLT, HTML to XML, understanding external Website	0	Jul 15, 2012
Wrong Coding	5	Apr 19, 2023
I am trying to make an audio player, how do I get the selected file to be playable?	5	Mar 29, 2022
Angularjs newbie - second JSON datasource does not display	0	May 18, 2022
How to position the tooltip comment on these buttons?	9	Nov 4, 2023

XML dates

adam bob

Martin Honnen

adam bob

Ben

adam bob

Nicolas George

Joe Kesselman

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads