Date calculation question
Posted on 2013-01-24
On a form I have a field named "txtAck_Date". Also on the form I have a field named "txtTotalLTdays" which is a number field. Then there is a 3rd field on the form named "txtProdDate".
I need the field "txtProdDate" to be a calculated field. When the user enters a date in "txtAck_Date" then "txtProdDate" has to be "txtAck_Date" MINUS the days in "txtTotalLTdays" BUT NOT INCLUDING WEEKENDS (Saturdays or Sundays).
For example, using February of this year, if the user enters 2/21/13 in "txtAck_Date" I need to have "txtProdDate" back up by 20 days if "txtTotalLtDays" is 20. Therefore "txtProdDate" would be automatically calculated to be 1/24/13.
I can't figure out what the afterupdate event code would be for "txtAck_Date".