Filter for created on "X days" ago in table list view

[Kumar38]

I need to use a encoded query for "created on 2 days ago" . i.e; If I run query on Nov 29 , it should show me results from Nov 27 , irrespective of time.

Below responses are returning results in a way that if i run on Nov 29 , 1 pm , it returns results for Nov 27 , at or after 1 pm . I am loosing data between 12 am to 1 pm

How can I run this in filter to use it for encoded query.

[Tai Vu]

Hi @Kumar38 

Let's use the relative condition, and you can set with minutes, hours, days, etc.

Sample below.

Cheers,

Tai Vu

[Sagar Pagar]

Hi @Kumar38,

You can use filter as -

Created BEFORE Yesterday

OR

Created RELATIVE BEFORE 2 Days ago

If my response helps you resolve your issue. Kindly mark it as helpful & correct. It will be helpful to future readers! 👍🏻
Thanks,
Sagar Pagar

[Kumar38]

Hi , Updated my question

[Danish Bhairag2]

Hi @Kumar38 ,

It should be something like this 

sys_created_onRELATIVELT@dayofweek@ago@2

Thanks,

Danish