Skip to main content
Nintex Community Menu Bar

Site Workflow Current Date

  • Nov 20, 2015 8:14 PM UTC
  • 7 replies
  • 48 views
  • Translate All

Forum|alt.badge.img+8

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

7 replies

Forum|alt.badge.img+11
  • Scholar
  • Nov 20, 2015 8:24 PM UTC

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.

Translate

Forum|alt.badge.img+8
  • Author
  • Rookie
  • Nov 20, 2015 8:41 PM UTC

Apologies I actually did mean to write Current Date.

Translate

Forum|alt.badge.img+7
  • Nintex Partner
  • Nov 20, 2015 10:36 PM UTC

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 ?

Translate

Forum|alt.badge.img+8
  • Author
  • Rookie
  • Nov 23, 2015 1:16 AM UTC

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

Translate

Forum|alt.badge.img+8
  • Author
  • Rookie
  • Dec 4, 2015 6:22 AM UTC

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

Translate

Forum|alt.badge.img+11
  • Scholar
  • Nov 1, 2016 6:14 PM UTC

,

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

Translate

Forum|alt.badge.img+8
  • Author
  • Rookie
  • Nov 8, 2016 8:40 PM UTC

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

Translate