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...
Need Help
  • Vvelarde's avatar
    Vvelarde
    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
CPSTC's avatar
CPSTC
Regular Visitor
8 years ago

Thanks for your help Greg_Deckler