validate time field (no date)

Hey Marian!

Yes, my current regex validates the time is HH:MM format and the dropdowns are AM/PM. So far the HH:MM validation works great but I'm not sure how to make sure they don't add a start time that's after the end time.

Honestly, I feel like the users should be able to figure it out on their own, and if it's not correct, it's probably just an miss-type. Once the form is submitted, it adds the event to a calendar so it would cause issues if they do mess it up.

Thanks for your help!

Kassie

Probably no to the military time.  That would be an excellent fix though!

Hi,

If you can add few line of jquery to your Nintex, you can follow this approach.

1. Create 2 date & time columns in list for this, BeginDate, EndDate are your column names, and set their default date value to "Today".

2. Drag them on your form and name them, ctrlBeginDate, ctrlEndDate.

3. Use the below script in form settings to hide date portion of both controls.

NWF$(document).ready(function () {

NWF$('#' + ctrlBeginDate).next('img').hide();
NWF$('#' + ctrlBeginDate).hide();
NWF$('#' + ctrlEndDate).next('img').hide();
NWF$('#' + ctrlEndDate).hide();

});

4. Create a rule for comparing time (the both controls will have the default date set to "today", so, the comparison will be BeginDate's control date&time and EndDate's control date&time). And ignore the stroked out portion, that is not required in your requirement.

5. Form at run time will be shown as below.

Thanks,

Krishna.

does the time input have to be split to two fields?

if you could make it single filed, and if time is always entered in the same format as defined by current user's locale the the validation could be as simple as comparing control1 < control2

maybe it's not obvious, but you can take advantage of (sometimes pleasant, sometimes unpleasant) 'feature' that nintex tries to 'understand' values entered in (some) controls and convert it to a datatype/object that they resemble to.

in your case it means that if time input control is populated with a value that fits to time format defined by current user locale, nintex automatically converts it to Date object(s) which could be directly compared.

see following exercise

details on controls used

input boxes

'Value' calculated value controls

'typeof(value)' calculated controls

comparison calculated value controls

BUT, if you are going to use time inputs to make a calendar event anyway, I wouldn't complicated things on both ends, and used (and strongly recommended to use) regular date controls.

besides of input validation problems, guessing to what date (day) times are related to when creating calendar event, consider as well situations when eg. an item will be created shortly before midnight and workflow (calendar event creation) will take its turn after midnight.

or, if workflow fails or need to be rerun the other day.

how in these scenarios will you identify correct date, the time is related to?