I am trying to validate the TIME on a date/time function.
I manage to validate the date but the time is always set to 00:00 by default.
If someone does pick the date but not the time > the validation goes through.
However, it is important that the user also picks the relevant time.
Yes, the process is to set the time but some users do not follow the instructions.
How would I be able to validate if the time is set to 00:00 then display error "please select the time..."
Solved! Go to Solution.
Hi Bim. I think I was able to figure it out. Try the steps below and let me know if it works for you.
This is what I already tried and strangely it does not work at all!
The calculated field does not show any figures when running a test ....
However, the calculated value shows the value only when the form has been submitted.
The BookingDateTime format is set to: Standard.
I have come across the following article in the forum: Validate Time portion of date/time control in a form
whereby Marian Hatala suggested the following formula as a validation
In my case, I am using the 24hr date format and had to change the formula as following:
in hope there won't a be a flight at 00:00 lol