issue in current month

[soniasweety]

Hi all,

@Vegar 

@sunny_talwar 

im  using text object  to show the max month data  .

and using below expression not working.

YearMonth = 2020-Jul, 2020-Aug   

when open the dashboard i want to see max month data text object and it should show  based on yea month selection it should chnge.

tried below exp:    count({<status={'yes'},YearMonth={'$(=Month(today()))'}>}id)

[tresesco · Accepted solution]

Try like:

count({<status={'yes'},YearMonth={`$(=Date(today(),'YYYY-MMM'))`}>}id)                 // note, inverted quotation

[Vegar]

As @tresesco  is showing in his reply - you need to format the output of your today() expression so it matches the format in your [YearMonth] field.

Your present expression where trying to compare YearMonth to a month short name like 'Aug' or 'Sep' depending on the output of today(). 

[sunny_talwar · Accepted solution]

You can also try

Count({<status = {'yes'}, YearMonth = {"$(=Date(Today(), 'YYYY-MMM'))"}>} id)

or

Count({<status = {'yes'}, YearMonth = {[$(=Date(Today(), 'YYYY-MMM'))]}>} id)