Problem with Sheet Trigger Selecting Date Type?

[SDT]

I am attempting to use the new Sheet Trigger functionality in the April 2020 release.

In the data load, I am defining the following fields:

LET vStartDate = Num(makedate(2017,10,1))

Date($(vStartDate) + RangeSum(Peek('RowNum'), 1) - 1) AS Date

 Date(MonthStart(Date),'YY-MMM') as CYMo

 So I set up a sheet trigger using "Select values in a field" option and field CYMo and entered the following formula in the value box:

 =Date(MonthStart(Today(0),'YY-MMM'))

 I also tried

=(Date(MonthStart(Today(0),'YY-MMM')))

 Neither one worked.

 Oddly enough, it works when I choose Toggle Field Selection instead of "Select values in field". I have confirmed the "Select values in field" works with other field types and manual entry of the value(s).

[SDT · Accepted solution]

Lots of trial and error and solved this.

Had to match the numeric date value for it to work:

=$(=NUM(Monthstart(Today(0))))

This should be in the Qlik documentation for this feature when matching dates in sheet triggers.