How do I compare 2 dates that involve hours ?

  • 14 February 2017
  • 4 replies
  • 6 views

Badge +9

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 ?


4 replies

Userlevel 5
Badge +12

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.

Userlevel 5
Badge +12

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

Badge +9

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

Badge +6

Hi David ,

This will help you. Please check   

Regards 

Bashya Rajan A

Reply