It will not send the email. There are also no errors or warnings listed in the instances. It looks to me like if the field I am looking to pull information from is applied to a document, rather than a folder, it will not work.

Does the search find any documents? (there should be a message on the Messages tab in the instance details with the number of search results).

No, it never finds anything if it is a field assigned to just the document.

Can you post screenshots of both your search activity and of the attachment settings in the email?

I think Jennifer meant a screenshot of the search criteria in Search repository and the Messages tab so we can see if the search found anything. Your screenshots above show the search still running, so we can't tell what's going on. 

How is your date token calculator set up?  A quick glance of your search query looks good so I would like to narrow down possibilities.  Can you put the track tokens activity right after the date calculator to verify what date is being produced when it runs?

Silly question, but if you run the same search in the Client (or Web Access), does it return any documents?

This might sound like a silly question but have you verified that there are actually documents in your repository that have the current date in the field you are searching?

From what I have read in the chain it does not sound like your workflow is actually broken but rather it finds no results in the search so the for each loop doesn't actually run (hence no email).

Hi,

Yes I have set several files to the correct date for testing.

How is the Policy Review Date field set up?  Text or Date?  MM/DD/YYYY or DD/MM/YYYY?

Your token is returning MM/DD/YYYY but I noticed that on your shot of the workflow showing no results found the date/time of the activity shows as DD/MM/YYYY.  Just want to check and make sure that the date token value is matching the format of the actual field value.

The field is set up as DD/MM/YYYY as in the picture above. 

I should mention that as a test, I moved this document to a folder and set today's day on that folder as the policy review date. I changed the setting to attach the folder rather than the document and it worked immediately.

Have you tried changing the search query to specify looking for documents?

You have me very curious now!  I have recreated exactly what you have and it works fine.

What version of Workflow are you on?  Have you left the document in the folder but leave the date on the document instead of folder?

Hmmmm. I'm not sure how I would change the search query. I am relatively new to workflow. We are on version 9 of workflow. Yes, I have tried having the date just on the document and not the folder. It is baffling me!

One hint that I was given a long time ago was to build your search in client then copy it over to workflow.  If you go into Client and set up your search with the field, Name, and Search Syntax, it will build the search for you and all you have to do is copy it.  Use the Field Search to select the field and put in a date (this can be changed once in workflow), Use Name and put the * wild character in the field with Document checked.  Press the Search button and it will populate the Search Syntax field for you .  Then just copy and paste.

Once you paste it into workflow, replace the >= with = to look for just one date, and replace the date with your search token.

Have you check both workflow and workflow admin console to verify the most recent version of the workflow is running?  Maybe Workflow Subscriber service needs to be restarted?

Do a search in workflow designer on the workflow by name to get a listing of all the times it ran.  Look at the workflow version that is running (might have to add the column).  Then go into workflow admin console and look at workflow definitions under Workflows and make sure the version number of the most recent test runs matches what admin says is the most recent version.