nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

My Community
Groups
Browse Categories
Members
Jobs Board
Help
Discussions
Categories
Groups

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

Find more posts tagged with

Comments

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of