


Views
Replies
Total Likes
Views
Replies
Sign in to like this content
Total Likes
hi Annie,
place the below code in the exit event of the date field and script language should be FormCalc
if
($.rawValue <> null )
then
var
num = IsoDate2Num($.rawValue)-Date()
if
( num > 0 )
then
$host.messageBox("Invalid Date and cannot be Future Date")
$.rawValue
= ""
$host.setFocus("your field path")
endif
endif
Note : your field path for example your date field name is futuredate under subform name body then place body.futuredate.
if you want to resrict not to enter past date then compare num with < 0 or to current date then compare num with = 0.
Thanks,
Madhu.
Views
Replies
Sign in to like this content
Total Likes