Poser une questionPoser une question
 

TraitéeXSLT Filter - FormatDate?

  • mardi 1 décembre 2009 16:39JCNET Médailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateur
     


    I have this filter on a DataView in sharePoint Designer. It's allowing me to filter on partial match from a parameter on several columns. It works for all columns except date columns.  In addition to text, I'd like the operator to be able to enter partial strings  for example "12/1" and "/1999"


    [contains(translate(concat(' ',@Entity,@Name,@SurgeryDate,' '),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','abcdefghijklmnopqrstuvwxyz'),translate($Search,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','abcdefghijklmnopqrstuvwxyz'))]


    I've tried these two, the first gives me a syntax error and the second does not work.

    (FormatDate(string(@SurgeryDate) ,1033 ,1)),

    (string(@SurgeryDate))

    Currently that date data looks like this on screen

    12/1/1999
    12/1/2005

    and looking at the XSL code for the dataview, the row data is formated as such:

    <xsl:value-of select="ddwrt:FormatDate(string(@SurgeryDate) ,1033 ,1)"/>

    Thanks.

Réponses

Toutes les réponses