Community
Showing results for 
Search instead for 
Do you mean 
Reply

Finding new records BETWEEN 2 dates

Highlighted
New Member
Posts: 60
Country: USA

Finding new records BETWEEN 2 dates

  1. I have a date field called NEXT CALL
  2. I want to find all the contacts where the next call date...
    1. Is on or before TODAY
    2. But also NOT beyond the date of 11/18/19.

Is this possible???
Thank you!!

 

Highlighted
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Finding new records BETWEEN 2 dates

To meet both conditions you would need to go to Lookup | Advanced |Advanced Query.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
Highlighted
New Member
Posts: 60
Country: USA

Re: Finding new records BETWEEN 2 dates

That's correct. How do I structure the query??

Highlighted
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Finding new records BETWEEN 2 dates

field >= start date AND field >= end date =
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
Highlighted
Silver Contributor
Posts: 2,059
Country: United_Kingdom

Re: Finding new records BETWEEN 2 dates

I think he is trying to find dates from Today but before another future date.

 

I differ slightly with Roy

 

Chosen Date Field ON OR AFTER today

 

AND

 

ON OR BEFORE "insert date"