Fiter in expression issue

stekol61 — Thu, 07 Mar 2019 13:19:16 GMT

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,

Re: Fiter in expression issue

sunny_talwar — Thu, 07 Mar 2019 13:29:10 GMT

May be try this

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