I kept digging and found a formula that works:

{ticket.dateshipped} >=date(2018,01,01) and
{ticket.dateshipped} <=date(2021,04,30)

I was trying to have them be one line and use "between" or something like that.

I first entered the date as 01/01/2018 and it returned all dates, including those before 01/01/2018. Changing the formatting to 2018,01,01 fixed that.

Edited by bjfils - 12 May 2021 at 7:57am

Thanks for another option!