Need report on problem table where RCA date is exactly 2 days from now

[Mayura1997]

Hi,

I tried few conditions using relative option but unable to get the exact data. Can anyone help on this.

Thanks in advance.

[AnveshKumar M]

Hi @Mayura1997 ,

Try this one on RCA date field.

[Mayura1997]

Hi @AnveshKumar M 

Thanks for the reply. I have used this condition and i am getting all records where RCA date is after 2 days from now and i need only the records which are exactly 2 days from now.

EX: 

First record  : Rca date is 22

Second record : Rca date is 23

Today's date is 19

so i need first record to display on the report not the second record.

Thanks,

Mayura

[AnveshKumar M · Accepted solution]

@Mayura1997 

Use and condition and the following filter in combination to the above one.

[Mayura1997]

Hi @AnveshKumar M 

I achieved it. Thanks for the response.

Thanks,

Mayura