cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How do I compare 2 dates that involve hours ?

Jump to solution

I simply within the Query List want to compare if the Current Date Time exceeds the Due Date.  Thus if it is now  02/13/2017 8:30 AM  I want to compare a due date of 02/13/2017 8:00 AM.  

Pure Date comparisons seem to work but not time.  This is important since I need to notify people once the time has expired that their task is late.  In the above example my site workflow that runs at 8:30 AM should send out a note that the 8:00 AM task is late...

Any suggestions on this date/time compare ?

Labels: (1)
0 Kudos
Reply
4 Replies
Workflow Hero

Re: How do I compare 2 dates that involve hours ?

Jump to solution

Check out What is the best way of comparing two dates in a workflow?  and scroll towards the bottom.  Donna Fox wrote up some good ways to pull this off.  Although she's removing the times from the equation, you can utilize very similar concepts.

Reply
Workflow Hero

Re: How do I compare 2 dates that involve hours ?

Jump to solution

Check this out also since it has some good comparision ideas with times involved: https://community.nintex.com/message/32146?commentID=32146#comment-32146 

0 Kudos
Reply
Workflow Hero

Re: How do I compare 2 dates that involve hours ?

Jump to solution

So if I use Donna's format function example including the hour will this work for her Set a Condition example ?

0 Kudos
Reply
Workflow Hero

Re: How do I compare 2 dates that involve hours ?

Jump to solution

Hi David ,

This will help you. Please check   

Regards 

Bashya Rajan A

Reply