Is it possible to validate date fields in the customer portal

Question

I just discovered today that customer's can enter dates and times in the date fields on the customer portal that are in the past. For example, they can request a due date that has already passed.

Does anyone know if there is a way to either make it so they can't pick a date/time later than the current time or warn them that they are picking a past date? Also similar is there a way to validate against a date/time, for instance not allow them to enter a due date that's within an hour of the current time?

Marshall Curtis · Answer

Nearly two years later I see we have a feature request JSDCLOUD-10703

It seems obvious that when creating a form that most references on the form should be relative.  Otherwise, there is little value in the validation.  As soon as I set a date it's no longer valid.  e.g. New user requests must allow 3-business days.  So the earliest start date is three days from the date the user is completing the form.  As it currently is I would need to have user call the Service Desk ask them to update the form so that they can complete it.  Really?

BTW the concept of relative is quite new, in was introduced in LOTUS 1-2-3 (circa 1980s)

Kate Caldecott_h6gk2b · Answer

Hi @Kimi Nakashima

Unfortunately you can only set earliest and latest date as parameters.  It is a good idea though which we will take on board.  We should allow users to specify either an exact date, or a relative date (i.e. 3 weeks from the current date).  Thanks for giving us that as a suggestion and I am sorry that we could not be assist in this scenario.  Please feel free to reach out as needed.

Kimi Nakashima · Answer

@Kate Caldecott Coincidently, we happen to be running a trial of the server version of ProForma. (We're running a trial of JSD server and ProForma is one of the apps we're looking at). I saw where you can set a date validation, but I was wondering if it's possible to validate it against the current date as opposed to a set date. Or validate against the current date plus one day.