Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi, Another way is using the Query Editor
Regards
Victor
Lima - Peru
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