How do i filter records that expiring exactly on next 3 months from today?

[omsa1]

Hi ,

I want to filter records that will be expired in exactly 3 months from today(today+90days). I can't filter 3 months with "on" and "relative" operator. Any suggestion how to filter using breadcrumb?

[Ankur Bawiskar]

Hi,

try this

Date Relative After 90 Days from Now

AND

Date Relative Before 91 Days from Now

Regards
Ankur

[Ankur Bawiskar]

@omsa 

Did you check the above approach?

Regards
Ankur

[omsa1]

Hi Ankur,

Its not returning any result but I do have records that has expiry date 90 days from today. if today April 13,2022 , 90 days from this would be July 12,2022. 

[Ankur Bawiskar]

Similar condition has worked for me earlier.