DateAdd for expiry and reminder dates


G

Guest

Rephrazing a previous question. Preabmle: understand that a table filed
should not contain a calcualted value, how do I work around that to achieve
the following:

Items being received on any given date will have a default expiry date of 3
months, however users may overide that to any expiry date they wish. also
want to set a reminder date for 7 days prior to expiry date. Need to be able
to store data as report on reminders due to be sent and expiring items on any
given day. \

Seems I can use DateAdd("m",3,Date()) as the default value for the expiry
date, but not DateAdd("m",3,[ReceivedDate]) - is it not possible to do that ?
 
Ad

Advertisements

D

Douglas J Steele

It's not possible in a table, but then you shouldn't be using a table to do
your updates.

In a form, you can easily set the value of any field in the Current event of
the form and/or the AfterUpdate event of whatever control(s) impact the
value.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Anth said:
Rephrazing a previous question. Preabmle: understand that a table filed
should not contain a calcualted value, how do I work around that to achieve
the following:

Items being received on any given date will have a default expiry date of 3
months, however users may overide that to any expiry date they wish. also
want to set a reminder date for 7 days prior to expiry date. Need to be able
to store data as report on reminders due to be sent and expiring items on any
given day. \

Seems I can use DateAdd("m",3,Date()) as the default value for the expiry
date, but not DateAdd("m",3,[ReceivedDate]) - is it not possible to do
that ?
 

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

Top