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?
Thank you for your help! Worked like a charm! Many thanks!
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
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.
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 = ""