Set filter for 2 days ago using filters

[Kumar38]

I assume its not possible , but wanted to confirm. I have a date time field and I need to run the filter so it pulls in records with "Started Time" of 1/19 , assuming I run it on 1/21. [Irrespective of time]

Tried below and it pulls in records based on date and time , i;e , If I run it on 1/21 7pm , it pulls records on 1/19 with a "Started Time" of 7 pm or after.

"Started Time" before yesterday AND "Started Time"  relative after 2 days ago 

[Maik Skoddow · Accepted solution]

Hi @Kumar38 

yes it is possible with a workaround. You will need "SN Utils" browser extension to be able of entering an encoded query in the list view:

The encode query to fulfill your requirement is (replace window_start and window_end with your field names and also : with a colon accordingly as this is always replaced by the Community portal due to security reasons)

window_start>=javascript&colon;gs.daysAgoStart(2)^window_start<=javascript&colon;gs.endOfYesterday()

Maik