Skip to main content
Nintex Community Menu Bar

Suppress Submit control based on time of day

  • Feb 14, 2017 4:08 PM UTC
  • 6 replies
  • 30 views
  • Translate All

Forum|alt.badge.img+1

I have a Nintex form which I would like to have only be available from the hours of 7p to 7am.  I have tried several  validation conditions of the Submit button and I can get it to work if I say within the same single digit hour range.

For example if I put Current Time is >=7:00 pm && Current Time <=9:59 PM it will work, but if I change it to a range between say 7pm and 10:00pm it will not.

(Current Time >'7:00 AM' && Current Time <'7:00 PM') will not work

Even tried to other things like this.

((Current Time>='07:00 AM' && Current Time <'12:00 PM') || (Current Time>='12:00 PM' && Current Time <'7:00 PM'))

But I cannot get it to work.

This does work

(Current Time >'10:00 AM' && Current Time <'10:59 AM')

Any ideas or a different way to approach this?

6 replies

Forum|alt.badge.img+14
  • Scholar
  • Feb 17, 2017 12:12 PM UTC

something like this could work (if current time falls between 07:00PM and 07:00AM - formula return true)

 formatDate(Current Time,'HH')*60 +formatDate(Current Time,'mm')*1 < 7*60 &&  formatDate(Current Time,'HH')*60 +formatDate(Current Time,'mm')*1 > 19*60‍
Translate

Forum|alt.badge.img+1
  • Author
  • Feb 18, 2017 3:34 AM UTC

Excellent thank you.  I have entered it to see if it does the trick.  Thank you kindly.

Translate

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • Feb 18, 2017 5:23 AM UTC

I am super curious what kind of form requires this type of validation! Is it like an IT support form? (No need to answer if you don't want, I just have never seen a button reject me if it's 2AM before...)

Translate

Forum|alt.badge.img+1
  • Author
  • Feb 18, 2017 5:37 AM UTC

We have remote agents that need to address form submissions in as close to realtime as possible (under 20 minutes).  However, we only have agents available for 12 hours a day.  Otherwise the endusers need to contact onsite support by another method.  

I did not want end users submitting the form when it is unmonitored, and bypassing their onsite support.  I put instructions on the form, but we found that users were submitting forms during off hours and expecting someone to be answering it.

Translate

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • Feb 25, 2017 7:27 AM UTC

Hey ‌ -- did ‌'s solution work out for you? 

Translate

Forum|alt.badge.img+1
  • Author
  • Feb 25, 2017 2:08 PM UTC

It did. I did think I marked as helpful/solved.

Solution works great. I actually wanted the opposite effect so I just had to change the times but it worked no issue. Thank you.

Translate