AnsweredAssumed Answered

How to compare current datetime to a datetime field on form?

Question asked by jr204 on May 4, 2015
Latest reply on May 5, 2015 by jr204

I need to compare the current datetime to a datetime field on my Nintex form for validation purposes.  I'd like to ensure date and time entered in the form has already passed and does not occur in the future.

 

I am encountering one issue though, which does not make this as straightforward as I'd initially thought.  The Current Date field returns the correct date, but always with 12:00 AM as the time.  The Current Time field just provides the time, for example 12:28 PM.

 

Is there a built in way to access the full, current datetime with the correct time?  If not, what would be the simplest way to format the Current Date and Time reference fields so that they can be compared to another datetime field using a Boolean function (in this case, greater than or less than).

 

Thanks!

Outcomes