Fiter in expression issue

[stekol61]

I have an expression with some filters.

When I hardcode a date as 'Week_S={'2019-10'}' the result is OK.

However, I want to always use current date so I have loaded 'CurrentWeek'.

What would be the syntax for using 'CurrentWeek' (or maybe some other solution)?

Count({<Week_S={'2019-10'} , wor_country_S >} wor_ticket_ID_S)

(Year(Today()) &'-'& Week(Today())) as CurrentWeek,

[sunny_talwar · Accepted solution]

May be try this

Count({<Week_S = {"$(=MaxString(Week_S))"}, wor_country_S>} wor_ticket_ID_S)