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.