Skip to main content
Nintex Community Menu Bar

How can a validate date and time

  • May 12, 2017
  • 10 replies
  • 38 views

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...


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

Forum|alt.badge.img+1
  • Author
  • May 12, 2017

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.


Forum|alt.badge.img+1
  • Author
  • May 12, 2017

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.


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.


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

hwo do you compare it?

see following how should it work  


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


Forum|alt.badge.img+1
  • Author
  • May 20, 2017

This works. Thanks!


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!


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