Number of Dates selected

[jerryr125]

Hi - I have a filter that selects the date (field: DATE).

I am using this formula to display the dates selected.

GetFieldSelections(DATE)

What if I want to count the number of DATES selected ?

I tried this :

COUNT(GetFieldSelections(DATE)) and it returns a 1 when I select 5 dates.

thoughts ? Jerry

[JordyWegman · Accepted solution]

Hi, 

Use this formula:

IF(Count(Distinct Date)=Count(Distinct {1<Date =>}Date),0,Count(Distinct Date))

As extra the formula looks if you made any selections. If you have selected none, it will return 0.

Jordy

Climber