Skip to main content
Nintex Community Menu Bar

How can a validate date and time

  • May 12, 2017
  • 10 replies
  • 51 views
  • Translate All

Forum|alt.badge.img+1

I'm having trouble producing a error if start date and time is greater than end date time. It only compares dates, but not time. I need both compared.

10 replies

Forum|alt.badge.img+14
  • Scholar
  • May 12, 2017

we need more details on what you trying to do, what error do you get, what environment you work on, is it for form or workflow, etc, etc...

Translate

Forum|alt.badge.img+9

Forum|alt.badge.img+1

I'm using SharePoint Nintex form. I have two columns in the form. Meeting_Start captures the date and time for the beginning of the Meeting. Meeting_End captures the date and time the meeting ends. I'm using a validation control to compare date and time to make sure that the user doesn't select a start date and time that is great than the end date and time. Also, the reverse for End_Meeting. The control only compares the dates and throw an error when it sees the same date. For example: 5/12/2017 12 pm is start and 5/12/2017 1pm is end. I'm getting the error message I created because it's only comparing dates and not date and time.

Translate

Forum|alt.badge.img+1

I'm using SharePoint Nintex form. I have two columns in the form. Meeting_Start captures the date and time for the beginning of the Meeting. Meeting_End captures the date and time the meeting ends. I'm using a validation control to compare date and time to make sure that the user doesn't select a start date and time that is great than the end date and time. Also, the reverse for End_Meeting. The control only compares the dates and throw an error when it sees the same date. For example: 5/12/2017 12 pm is start and 5/12/2017 1pm is end. I'm getting the error message I created because it's only comparing dates and not date and time.

Translate

bamaeric
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • May 13, 2017

Check out the Date and Time Format Strings - Quick Reference Guide article from Andrew Glasser and see if this helps with the date formats.

Translate

Forum|alt.badge.img+14
  • Scholar
  • May 13, 2017

hwo do you compare it?

see following how should it work  

Translate

Forum|alt.badge.img+17
  • Nintex Partner
  • May 19, 2017

So you can't do this? My Validation Rule is comparing the two controls by time.

203275_pastedImage_1.png

203282_pastedImage_2.png

Translate

Forum|alt.badge.img+1

This works. Thanks!

Translate

Forum|alt.badge.img+17
  • Nintex Partner
  • May 20, 2017

Awesome, glad we were able to help. Please mark the answer correct as to benefit others with the same question. Happy Nintexing!

Translate

Forum|alt.badge.img
  • July 31, 2019

Hello ,

I am new for Nintex and trying to do

Nintex Forms 2013 , I want to validate a time field that's is a single line of text field so
 user enter the start time prior to the end time . The time formatted regex for validation (24-hour clock format  ). How can i accoplish this. 

Thank you very much for  your assistance.

Sosena

Translate