Yodelayheewho
Member
Hello!
I have two calculation challenges.
1. I've been searching and testing codes to calculate a promise date. The equation is PO received date + soonest lead time expressed in weeks = promise date.
txtLT = Lead Time and is formatted like this: 12 - 14 WKS
txtPORec'd = Date (ex: 01/02/2022)
txtPromDate = Date + the first two digits of the Lead Time (ex: 01/02/2022 + 12 weeks = 03/27/2022)
2. I also need to calculate an expiration date. The equation is proposal date + 60 expressed in days = expiration date
I found this example of the DataAdd function, but what I need isn't this straightforward. The following does not reference specific textbox values
I would appreciate your help.
I have two calculation challenges.
1. I've been searching and testing codes to calculate a promise date. The equation is PO received date + soonest lead time expressed in weeks = promise date.
txtLT = Lead Time and is formatted like this: 12 - 14 WKS
txtPORec'd = Date (ex: 01/02/2022)
txtPromDate = Date + the first two digits of the Lead Time (ex: 01/02/2022 + 12 weeks = 03/27/2022)
2. I also need to calculate an expiration date. The equation is proposal date + 60 expressed in days = expiration date
I found this example of the DataAdd function, but what I need isn't this straightforward. The following does not reference specific textbox values
Code:
dFutureDate=DateAdd("d",60,"mm/dd/yyyy")
I would appreciate your help.