Spotfire: Date filtering with action control
<p>I am working on a spotfire app and I am trying to create an action control that filters dates. I am new to ironpython and can't figure out what is wrong with my script:</p>

<pre><code>from Spotfire.Dxp.Application.Visuals import *
import datetime as dt

visual = viz.As[VisualContent]()
visual.Data.WhereClauseExpression = '[Agreement End Date] &lt; dt.date.today()'
</code></pre>

<p>When the above script is run I get "The expression is not valid after '(' on line 1 character 34. Here Agreement End Date is the column I am trying to filter on. I have looked around and haven't been able to find an answer (I realize this probably a very simple task for someone experienced in such things). </p>

<p>Any help is greatly appreciated!</p>