How do you subtract X number of weeks from a Date Field/

Pbhul

06-07-2015

Looking for a Script for subtracting X number of weeks from a Date Field.

Presently, Date Field is named RTL, Number of Weeks Numerical Filed is named NumericalField6.

Result Filed is aDtae field named DSPSE.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Pbhul

07-07-2015

DSPSE=Num2Date((Date2Num(RTL.formattedValue,"MM/DD/YYYY")-NumericField6*7),"MM/DD/YYYY")

I am using FormCalc to get durations(weeks)  from a given date and working back to obtain other Milestone dates.

Getting aprompt message everytime I add a duartion " Validate DSPSE".

Thanks.

Pbhul