i am trying create an report to show specific data from two different field. See below

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

im trying to create an report that show 20 days. for example if first date is 7/1/2015 and second date is 7/15/2015 than show but if it goes beyond 20 days it doesnt show on report. below is what i need..

List that show as DATE FIELD 1 from the DATE FIELD 2  within 20 days or less. 


is this possible in QB? if so how? i tried all that i knew but couldnt get it to work. 


Thanks, 

Photo of Y

Y

  • 40 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
You want to base the report on a Checkbox formula field with the following formula:

ToDays([DATE FIELD 2] - [DATE FIELD 1]) < 20


If the above formula field is named [Checkbox] you want the report criteria to be true.