Subtract #days from Date

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtract a year 2
Message box when DOB meets certain criteria 4
Allen Browne's Recurring events 0
Auto calculate date in form 6
Autopopulate a Weekdate from a Recieved date 5
Changing Time using a macro 1
Dates swapping 5
Calculated Field in Query - Date Format 5

Top