Forum Discussion

CPSTC's avatar
CPSTC
Regular Visitor
8 years ago
Solved

Count IF Column

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 

 

Need Help

5 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    CPSTC

     

    Hi, Another way is using the Query Editor

     

     

    Regards

     

    Victor

    Lima - Peru

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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