Dynamic search

Alex HartleyBishop

I am looking to set up a dynamic search which finds any requests which have the disposition of pending and their request date is 8 weeks ago or more. I have tried different solutions but each come up with errors in the code and wondered if anyone here had any ideas for the correct formula?


The search would be for a dashboard so would need to work dynamically from the date you are looking at it.


Thanks,

Alex 

Justin Finighan

Hi Alex,


This should work for you. Past into the Advanced Search.


Requests.Disposition = 'Pending' AND Requests.Request_Date < (GETDATE() - 56) 


Cheers

Justin