Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date range - setdateyear

analyzing a set of data between 2 dates

achieved for the current year:

Count (if ((Created-ReportFromDate)>=0 AND (ReportToDate-Created>=0), Description))


but when I try to apply the same logic for the previous year by using the setdateyear function, it does not work anymore

Count (if (((SetDateYear([Created],2010)-SetDateYear(ReportFromDate,2010))>=0 AND (SetDateYear(ReportToDate,2010)-SetDateYear([Created],2010))>=0), Description))


Any idea?

QV PE 10

0 Replies