Count IF Column

[CPSTC]

Hi All,

I have a number of columns that are dates, What I want to do is to create a column that counts how many of those dates fall between a specific date range.

For instance I have a record CNTRCT1 that has multiple dates - I want a count of how many of those dates fall between a specific range 

Is this possible with a custom column, could anybody give me any pointers on how to do this?

Thanks 

[Vvelarde · Accepted solution]

@CPSTC

Hi, Another way is using the Query Editor

Regards

Victor

Lima - Peru

[CPSTC]

Great! Thanks for your help @Vvelarde

[Abduvali]

@Vvelarde

Brilliant =D

[Greg_Deckler]

Bit brute force, but how about this?

MyCount = 

VAR date1 = IF([Date] < DATE(2017,08,19) && [Date] > DATE(2017,08,15),1,0)

VAR date2 = IF([Date] < DATE(2017,08,19) && [Date] > DATE(2017,08,15),1,0)

VAR date3 = IF([Date] < DATE(2017,08,19) && [Date] > DATE(2017,08,15),1,0)

VAR date4 = IF([Date] < DATE(2017,08,19) && [Date] > DATE(2017,08,15),1,0)

VAR date5 = IF([Date] < DATE(2017,08,19) && [Date] > DATE(2017,08,15),1,0)

RETURN date1 + date2+ date3 + date4 + date5

[CPSTC]

Thanks for your help @Greg_Deckler