AnsweredAssumed Answered

How do I compare 2 dates that involve hours ?

Question asked by davidjohnson5000 on Feb 13, 2017
Latest reply on Feb 14, 2017 by bashyarajan

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 ?

Outcomes