Unfortunately it cannot be done with a scorecard but it can be done for the reports. Following is how:
Do we need to have SP-2 for this date control ?
The date control can be found under Time Intelligence filters.
The Date COntrol will not have any dimensiona associated know ? so I can create date control and how do i link to the dashboard ?
We need to pass to the MDX query as [Paiddate].[Date].&[2012-01-01]
Let me know if i can create greater than condition in filters ?
You cannot have the date control without a Time dimension. The Time Intelligence used the Time tab mapping under data source. You can treat your [Paiddate] dimension as Time dimension, if possible.
Alternatively you can create a drop down filter with all your non empty dates sorted descending and link that with the dashboard and reports.