Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Comparing two custom time fields
Hey,
I have two custom fields of type 'time of day' on an opportunity record:
1. appttime
2. apptendtime
These are used to record the time of the first appointment (a.k.a. event) for that opportunity. I have a script that automatically creates an event from this (and other) info.
I am trying to put some validation on the form that checks that apptendtime is later in the day than appttime. Therefore, I have used:
if (apptendtime <= appttime) {alert('apptendtime is not later than appttime')};
However, the <= operator isn't working properly. It returns true every time!
I have tried using standard date operators (e.g. getTime()) but these don't work. I think this is because the value in the fields are of type 'time of day' not 'date'.