prevent date in the past

Accepted Solutions (0)

Answers (4)

Answers (4)

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

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.

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