I have two fields, both are date/time fields. One is named start date and the other is named cancel date. I need the "Cancel Date" field to be 7 days from the start date e.g.( "Start Date" +7 days) Start date is formatted MM/DD/YYYY. Does anyone know the script for Form Calc to do this calculation?
DateTimeField2.rawValue = Num2Date(Date2Num(DateTimeField1.rawValue,"YYYY-MM-DD")+7, "YYYY-MM-DD")
Make sure to adjust the field names and display patterns in the above code sample
You are awesome!!!! Thanks you that is exactly what I needed.