1 person found this helpful
this is not so difficult to realize with FormCalc.
All you need is a date field and 7 check boxes with the same name such as "chkBox".
In the exit:Event of the date field add this script.
var selDay = Num2Date(Date2Num($.formattedValue, "DD.MM.YYYY"), "E") - 1
for i=0 upto 6 do
if (selDay eq i) then
chkBox[i].rawValue = 1
chkBox[i].rawValue = 0
Thanks for the responses. Is there a way to get the date to display in mm dd, yyyy format (December 2, 2001) instead of the day of the week?
Thanks a lot for your suggestion, it worked, one thing I had to change, though, was the date format to match what I have on the form. Once I changed that, it worked perfectly