Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this:
Count({1<[Month-Year] =- {'$(=Text(Date(Now(), 'MMMM')), & '-' & Year(Now()))'}>} CountRow)
Try
{'$(=Date(Now(),'MMMM-YYYY'))'}
How about this:
Count({1<[Month-Year] =- {'$(=Text(Date(Now(), 'MMMM')), & '-' & Year(Now()))'}>} CountRow)
Try this,
count({1<[Month-Year] -= {month(now())&'-'&year(now())}>}CountRow)
I would advise against using Now() as that constantly re-evaluates so the expression will have to recalculate itself repeatedly. Today() might be better.
not working...
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
Thanks it seems to be good idea and now includes in the formula