Date function on Field not working on a count

Question

I have a Count which is giving me the following error:

Error in set modifier expression

The Expression is:

=Count({<date(STARTTIMEDATE)={"$(=Date(Today()))"}>} IDID)

STARTTIMEDATE is in the format of YYYY-MM-DD HH:MM:SS:XXXXXX

score 1 · Answer 1 · answered Jun 21 '19 at 06:14

1

You need to match the date format of the test string to the original.

=Count({<STARTTIMEDATE={"$(=Date(Today(),'YYYY-MM-DD HH:MM:SS:XXXXXX'))"}>} IDID)

In my mind I read STARTTIMEDATE as only a label / pointer for WHERE the set analysis should look rather than as a function to be evaluated

answered Jun 21 '19 at 06:14

The Budac

I have tried this and it now shows results, but it shows ALL results the same as if i did `=COUNT(IDID)` – Matt Jun 21 '19 at 08:34

score 1 · Accepted Answer · answered Jun 21 '19 at 10:34

1

I have resolved this by using this in my load script:

CONVERT(VARCHAR(10),CAST(STARTTIMEDATE as DATE),103) AS STARTDATE

Then this as my expression:

=Count({$<YEAR=,STARTDATE={"$(=Date(Today()-1))"}>} IDID)

answered Jun 21 '19 at 10:34

Matt

2 Answers2