prevent date in the past

Avatar

Avatar

rickstsx04

Avatar

rickstsx04

rickstsx04

05-05-2015

I am trying to prevent a date field from allowing a user to enter a date prior to the current date. How can this be done?

Accepted Solutions (0)

Answers (4)

Answers (4)

Avatar

Avatar

rickstsx04

Avatar

rickstsx04

rickstsx04

07-05-2015

Thank you for your help! Worked like a charm! Many thanks!

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

06-05-2015

Correct, the pattern in the script has to be the one you use to display your date.

In the US it's generally MM/DD/YYYY and in Germany it's DD.MM.YYYY

Avatar

Avatar

mouslander

Avatar

mouslander

mouslander

06-05-2015

This works great. The pattern for the date field has to be set to whatever is in the script. I had my date field as MM/DD/YYYY and it would not work until I modified the formattedValue line to match the pattern for the field.

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

05-05-2015

Hi,

you can use a FormCalc script in the date fields exit event to inform the user an delete the invalid field data.


if (date2Num($.formattedValue, "DD.MM.YYYY") lt Date()) then


  if ($host.messageBox("You cannot select a date in the past", "invalid date", 0,0) eq 1) then


  $.rawValue = ""


  $host.setFocus(Ref($))


  endif


endif