topic Re: count number fo date from variable in Reporting Service & Alerting

count number fo date from variable

Modiz — Fri, 20 Sep 2024 08:34:16 GMT

Hi,

I have a variable like this:

v.excludeddate ='2024-01-01';'2024-09-01','2024-09-28','2024-10-05';

I need to count the distinct dates from this variable between the start of the current month and the end of the current month using a set expression.

when i use count distinct I get 1.

Re: count number fo date from variable

avinashelite — Fri, 20 Sep 2024 10:26:50 GMT

As per my knowledge at the variable level , I don't think its possible ...you could count the number of dates using the substringcount function and using the delimiter as the string to count

Re: count number fo date from variable

Vegar — Fri, 20 Sep 2024 11:28:08 GMT

You can do like this, without using set expression with SubStringCount()

=SubStringCount( v.excludeddate, date(today(), 'YYYY-MM'))

As shown in the image above. The number of september dates in the variable is 2.

Re: count number fo date from variable

Modiz — Fri, 20 Sep 2024 12:11:05 GMT

Thank you!