I was wondering if its possible to have a complex condition in modifier. For example I have a field RollingMonths which is of form "MMM-YYYY" (ex. 'May-2012') and I would like to create a comparision using current month and year. I've tried few different methods however none seem to work.
sum( {1<RollingMonth = {$(=date#(date(today),'MMM-YYYY'))}>} Units )
or
sum( {1<RollingMonth = {$(=month(today()) & '-' & year(today())))}>} Units )
I know the last option would be to create a variable.
Assuming that the RollingMonth field is text, your second expression should work with after a minor fix:
sum( {1<RollingMonth = {"$(=month(today()) & '-' & year(today()))"}>} Units )
I added quotes and removed extra ')'
If RollingMonth is numeric, your first expression maybe is closer to the correct one (except qoutes are missing and today has no '()') - but the exact syntax depends on how RollingMonth is defined.
