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.
Even tried to other things like this.
But I cannot get it to work.
This does work
Any ideas or a different way to approach this?
Solved! Go to Solution.
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
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...)
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.
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.