Need help with Set Analysis Dynamic Date

[#1]

I have two basic date based set analysis summations. One works (bottom) the top one does not.

The dynamic date generates the same date 04/01/2013 when I place it in a text box for testing.

Not sure why it still sums up all months regardless. No errors, but wrong summation.

Dynamic still sums up all months;

=Sum({$<RevMonth={'=Date(MonthStart(Today(2)))'}>} RevAmt)

Works for April 2013 perfectly for this date: 04/01/2013

=Sum({$<RevMonth={'04/01/2013'}>} RevAmt)

[Gysbert_Wassenaar · Accepted solution]

Try sum({$<RevMonth={'$(=Date(MonthStart(Today(2))))'}>} RevAmt)

[#3]

Well that worked perfect!  I guess I needed to add {'$(=... inside the modifier....

Thanks!