I would like to search my repository on a date field and return only results that are current date -30 days is this possible?
In Workflow, you can use the "Date Token Calculator" activity to create two tokens, one for the current date and another for the current date plus 30 days. Then you can use a "Search Repository" activity where the syntax would look like
{[]:[Date]>=%(DateTokenCalculator_Today), <=%(DateTokenCalculator_30DaysFromNow)}
You can definitely do this using the Search Pane. You may need to tweak the configuration a little bit to get it in line of what you're looking for but it will look something like this:
You can also use the date search and find files that have been modified in the last 30 days
Modified will not work the search needs to look at the Experation Date field and provide search results for entries Due to expire in 30 days. Example: If the search is conducted on 05-07-2014 the search should return entries that have a Field Value of 06-05-2014. Once I get the syntax to work I will use the it to run a workflow that will notify a user that a contract is due to expire in 30 days. I hope this explains it better.
Thanks
John
In Workflow, you can use the "Date Token Calculator" activity to create two tokens, one for the current date and another for the current date plus 30 days. Then you can use a "Search Repository" activity where the syntax would look like
{[]:[Date]>=%(DateTokenCalculator_Today), <=%(DateTokenCalculator_30DaysFromNow)}
That worked thanks for the help.
John