count number fo date from variable

[Modiz]

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.

[avinashelite]

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 

[Vegar · Accepted solution]

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. 

[Modiz]

Thank you!