How to set filter condition as 'most recent discovery - before - Last 20days'

Durgaprasad Jo1
Tera Contributor

Hello All,

While creating report, how to set filter condition as 'most recent discovery - before - Last 20days' in the snow report? We have option for 7days, 30days, 90days and 120days. How to set it for 20days?

image

3 REPLIES 3

Community Alums
Not applicable

Hi,

Please don't create duplicate questions!!

I replied to your other question: https://community.servicenow.com/community?id=community_question&sys_id=04b5ea40dbd51910f77799ead396...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

palanikumar
Mega Sage

Hi,

Use relative Operator

  1. Change Before to Relative
  2. Set the next dropdown as before
  3. Expand the next dropdown and choose
  4. First text box as 20
  5. Select Days in Next Radio
  6. Select ago as next radio

Refer below Screenshot

find_real_file.png

Thank you,
Palani

Ramamoorthy N
Tera Contributor

This should be 'Relative' search, so choose 'relative' as the operator and 'before' as the interval and '20 + Days + ago' as the duration. That should solve it.