In regards to the first issue it sounds like your XML uses a non-standard 
date format which makes conversion more tricky. I presume you're using XSLT 
1.0 (if you use .NET built-in stuff) so you have two options, either have 
some mapping in the XSLT that has the month names in some format like:
<ns:months>
  <month index="1" name="January" />
  <month index="2" name="February /"
  <!-- other months -->
</ns:months>
You can then examine the date string using something similar to 
http://geekswithblogs.net/workdog/archive/2007/02/08/105858.aspx but you'll 
need to check after for the string after the second space and before the 
third. You can then retrieve the index using ns:months/month[@name = 
$monthName]/@index.
Perhaps a search online would find a ready made example.
Alternatively you could use a C#/VB.NET function. I only use these if 
absolutely necessary, examples here: 
http://msdn.microsoft.com/en-us/magazine/cc302079.aspx
For the second part you need something like record[STATUS = 'ACTIVE'] 
although to be certain I'd need to see a small sample of the XML. You need 
to learn about predicates in XPath.


-- 

Joe Fawcett (MVP - XML)
http://joe.fawcett.name

"Savvoulidis Iordanis" <SavvoulidisIordanis@d...> wrote 
in message news:1CD36CE0-D1EF-4777-9CA3-CAD52E50C8E6@m......
> I'm creating a sports betting site in ASP.NET (VS2008). I've managed to
> create a transformed text file (CSV, semicolon delimited) based on a XSL
> transformation on a free XML file I've imported from another site, which
> contains the events and the odds. Unfortunatelly, the most significant 
> column
> (the event's date), is a string in the format of 'Sunday 14 December 
> 2008'.
> How stupid!
> So, being new to XML/XSL,
>
> 1. How can I write the transformation in my XSL file, so I get 14/12/2008
> displayed? (I don't need the day name)
>
> 2. How can i select only the XML records which have the value of 'ACTIVE' 
> in
> a STATUS field, into my CSV file?
>
> TIA
> Iordanis