XSL: Filter for Current Date

[whodeycp]

I have set up a webpage to display current conference room scheduling on a digital sign using XML data to load into the webpage using XSL. I want to be able to filter the XML entering the webpage by the StartDate that is specified in the XML by using the system current date. Does anyone have any example code that might help me in this struggle?

 

[simonchristieis]

You can pass a param into the xsl document that you could use to store the system current date.

<xslaram>

You would need to check on the correct forum for how you pass this through to your xsl file.

 

[Stevenm122084]

Simple... if your using the MSXML as your XSLT Processor this should work:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="

http://www.w3.org/1999/XSL/Transform"

xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
xmlns:date="myDateFunctions">

<msxsl:script implements-prefix="date" language="vb">
<![CDATA[

Public Function current(dateFormat As String)
Dim currentDateTime As DateTime = Date.Now
Return currentDateTime.toString(dateFormat)
End Function

]]>
</msxsl:script>

Then Output like this:

<xsl:value-of select="date:current('MM/dd/yyyy hh:mm:ss')" />

Simple huh?

Remember to always make a namespace/prefix for scrpits.. and to implemenet the prefix and the call the function with the prefix... simple..