Hello, I am trying to limit my select statement to return only rows with a due date between tomorrow and 60 days from tomorrow. I can figure out how to select anything due after today but I cannot figure out how to limit it to only dates due within 60 days of tomorrow. I tried a few different options and nothing comes out the way I expect it. I am using this in my WHERE statement to get all due dates after today but need to limit that to only the next 60 days:
WHERE dot.txt_NextDueDate > DATEADD(Day, +1, GETDATE())
I appreciate any help you can offer.
Note, I have converted this Date to varchar in SELECT statement