Using Nintex Forms 2016 in conjunction with SharePoint Server 2016. I am creating a "Request Off Form." The form contains 6 date controls:
Created, Current Date, Current Time, Today's Date, Request Start Date, and Request End Date.
Created = Common Property
Current Date = Common Property
Current Time = Common Property
Today's Date = List column, Calculated Value (1st pic)
Request Start Date = List column, Date/Time selector (2nd pic is the Rule)
Request End Date = List column, Date/Time selector (3rd pic is the Rule)
I want to use Rules to invalidate input: Request Start Date must be greater than or equal to Today's Date. Request End Date must be greater than Request Start Date. My validation works with respect to the dates, but does not work with respect to the times. For instance:
If Today's Date = 01/14/2019 10:00 AM, then Request Start Date = 01/14/2019 09:00 AM should be invalid.
If Request Start Date = 01/15/2019 10:00 AM, then Request End Date = 01/15/2019 08:00 AM should be invalid.
I have also attempted to convert both compared dates to the Sortable Date/Time:
lessThan(formatDate({Self},"s"), formatDate(Current Date,"s"))
This did not help...
Can anyone in Nintex-Land assist?
Thank you very much for your time.

