Since you are checking the format for 07/01/2011, try changing the format in the function.if (Date2Num(form1.#subform[0].Table1.Row2.date1.formattedValue, "MM/DD/YYYY") >= "07/01/2011")thenform1.#subform[0].Table1.Row2.rate1.rawValue = .555elseform1.#subform[0].Table1.Row2.rate1.rawValue = .51endifT...