use function in exclude part of expression

[#1]

Heloo for all,

I would like to help me with my problem. The following expression does not work and dont know why?

count({1<[Month-Year] =- {month(now())&'-'&year(now())}>}CountRow)

[Month-Year] contains January-2016, February-2016,...and I need to use expression and not the exact value

count({1<[Month-Year] =- {'January-2016'}>}CountRow)

This works fine. How could I write into {} that is the function and need to calculated and convert to string?

Thank you in advance.

Regards,

Peter

[swuehl]

Try

{'$(=Date(Now(),'MMMM-YYYY'))'}

[sunny_talwar · Accepted solution]

How about this:

Count({1<[Month-Year] =- {'$(=Text(Date(Now(), 'MMMM')),  & '-' & Year(Now()))'}>} CountRow)

[susovan]

Try this,

count({1<[Month-Year] -= {month(now())&'-'&year(now())}>}CountRow)

[michael_anthony]

I would advise against using Now() as that constantly re-evaluates so the expression will have to recalculate itself repeatedly.  Today() might be better.

[#6]

not working...

[#7]

This is working.....

Count({1<[Month-Year] =- {'$(=Text(Date(Now(), 'MMMM'))& '-' & Year(Now()))'}>} CountRow)

I have to delete the comma after double bracket )) and now works fine

[#8]

Thanks it seems to be good idea and now includes in the formula