Date Comparison in Set Analysis

[#1]

Kindly would you suggest what's wrong with this expression?

[Program Date] = {"<=$(date#(vSelectedDate, 'dd/MM/yyyy'))"}

Where vSelectedDate holds value as : 31 Jan 2013

[jagan]

Hi,

Try like this

Sum({<[Program Date] = {"<=$(=Date(date#(vSelectedDate, 'dd MMM yyyy')))"}>} Measure)

Please check whether the formats of date in [Program Date] and Date(date#(vSelectedDate, 'dd MMM yyyy')) are same.  If both are same then the above expression works.

Hope this helps you.

Regards,

Jagan.