Set Analysis with Dates

[#1]

I have been loving the set analysis.  It is really cool.  I am doing this one by date but its not working. 

=Sum({1<lead_submitted_date = {">05/01/2012"}>}num_leads_sold)

I want all records when the date is past 5/1/2012.  What am I doing wrong?

[swuehl · Accepted solution]

It's probably just a formatting mismatch. Have you double checked your lead_submitted_date format?

If you say, it is not working, what is your result? Zero, or a value that seems to be wrong?

[#3]

That was it.  I just fixed the date format and it worked.