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?
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Thank you for your help! Worked like a charm! Many thanks!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies