At the top of my form, I have a user defined field for the last date in a given week (Saturday)in the format MM/DD/YYYY. Below that there I have the days of the week (Sunday through Saturday). In this table each day should correspond with it's numerical counterpart.
For example, Saturday would be the user defined date, Friday would be the user defined date - 1, Thursday would be the user defined date - 2, etc.
So far I have a calculation in the "populated" area as FormCalc (where 'week' is the user defined date):
$.rawValue = Num2Date( Date2Num(week) - 1) )
else $.rawValue = ""
With the current formula, I get nothing, no errors or calculations.
Additionally I'd like the autopopulated date to be in the format of MM/DD rather than MM/DD/YYYY.
You may have to provide the format of the string being converted to a number. You can also format the result of the 'Num2Date()' function.
all of the fields are text input boxes with FormCalc and *calculate formulas...however given the formula above, i don't get anything, so should i change the formula all together or is there a better way to get these results? i'm new to the form building and XML stuff, so thank you for your patience