Dates in text form, trying to compare them to (current_date)

[ccbarbeau]

Hi,

I have a 2-list report; both have a number field that is cast in FM as a date in YYYY-MM-DD format. I cannot cast it as date in FM because it would require me switching my datasource to limited local processing, which I don't want to do right now.

So I'm trying to filter my report by 'date', but since RS sees the 'date' as text, it won't let me use an operator such as = or >, which makes sense. It does let me use 'contains' or 'starts with' though. Any ideas on how to work around this? I can't use something like

[datefield] starts with '2011-03'

then change the filter every month and re-publish... that would defeat the purpose if the report!

Thanks,

CC