Filling date fields in a single record based on a weekday selection
Posted on 2015-01-04
I would like to be able to fill date fields in a single record based on a weekday selection by a user.
for example if a user selected "Thursday" and then clicked a build Order button the resulting values in fields "Date01", "Date02" and "Date03" in the table would be "08/01/15".
I would like to use SQL but i am not restricted by it.
I would use a unique ID number to target the specific record to be updated.
Thanks in advance for any help or advice.