ctoper11
Apprentice

Site Workflow Current Date

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

Reply
7 Replies
kapilkjoshi
Apprentice

Re: Site Workflow Current Date

Hi Christopher,

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.

0 Kudos
Reply
ctoper11
Apprentice

Re: Site Workflow Current Date

Apologies I actually did mean to write Current Date.

0 Kudos
Reply
tbeduneau
Novice

Re: Site Workflow 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 ?

0 Kudos
Reply
ctoper11
Apprentice

Re: Site Workflow Current Date

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.

Proposal_Tracker_WF_1.PNGProposal_Tracker_WF_2.PNGProposal_Tracker_WF_3.PNGProposal_Tracker_WF_4.PNG

0 Kudos
Reply
ctoper11
Apprentice

Re: Site Workflow Current Date

Actually I'm still having the same issue. Anyone have any ideas?

0 Kudos
Reply
kapilkjoshi
Apprentice

Re: Site Workflow Current Date

,

Is this issue resolved? Could you please post your solution and mark the appropriate answer as correct to help others on the community.

Reply
ctoper11
Apprentice

Re: Site Workflow Current Date

Hello Kapil, unfortunately no it was not but my end users decided to go another route anyway. Thanks to everyone for their help

0 Kudos
Reply