AnsweredAssumed Answered

Date/Time Validation - Request Off Form

Question asked by lpetre on Dec 31, 2018
Latest reply on Jan 6, 2019 by euang

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 TimeToday'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)

 

Today's Date

 

Request Start Date

 

Request End Date

 

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. 

Outcomes