B
Bob
You could use DateAdd
=DateAdd("d",-127,[YourDateField])
If you want to be able to enter different target dates and
variations you can set up fields on your form and
reference the form fields in the control source.
=DateAdd("d",-[VariationField],[YourDateField])
=DateAdd("d",-127,[YourDateField])
If you want to be able to enter different target dates and
variations you can set up fields on your form and
reference the form fields in the control source.
=DateAdd("d",-[VariationField],[YourDateField])