VB6 - Retrieving records that fall within a date rage

[Giftx]

Hello everyone,
please I need clarification on date range calculation. My objective is to retrieve all records that is 90 days old from today's date:

I am using:

 Between Now() and DateAdd("d", -90, Now())

The above code worked but it doesn't look right to me and it is missing some records.

Any hint will be appreciated.

Giftx.