Hello. So I am trying to create a site workflow that will run daily. It is looking at another list specifically a particular date field on that list. When that date field equals today I want the site workflow to send and email to the person that created that line in the list. In the site workflow I'm using query list and filtering by Current Time but when I execute it's coming up blank. Any ideas Thanks so much
If you are comparing against Current Time then it doesn't have date component. The Current Time is in the format of HH:MM AM/PM.
For comparison against date field use Current Date.
Could you post a picture of your worlflow ?
I tested your need and it works for me :
- log current date
- query list where "DueDate" = Current Date --> Store Title in a variable
- log variable value : I get some items
What time does your Workflow run when scheduled ?
Sure no problem see below. I actually haven't even finished creating the WF yet so no schedule. I'm testing within the control and getting the below results. As you can see when I put the Current Date filter I get nothing back. But when I have no filter I get the below results. Including one for today (Sunday the 22nd) Thanks for your help.