Date add

  • Thread starter Thread starter lmossolle
  • Start date Start date
L

lmossolle

I have a field called rqrdate, I want to add 7 days to it and inset it to a
field called projdate. Could someone please assist?

Thanks!
 
To add seven days is easy. In query design view grid scroll to the right
to a blank column and type in the Field row the following -- projdate:
[rqrdate]+7
But you should not store the results as the data can be outdated in the
future. Just display the calculation when and where needed.
 
Depends: Your policies might change or for other reasons. rqrdate and the
field for 7 is saved then you don't need to save as projdate. However if you
save both rqrdate and projdate then you can recalculate the 7 by projdate -
rqrdate.
KARL DEWEY said:
To add seven days is easy. In query design view grid scroll to the right
to a blank column and type in the Field row the following -- projdate:
[rqrdate]+7
But you should not store the results as the data can be outdated in the
future. Just display the calculation when and where needed.
--
KARL DEWEY
Build a little - Test a little


lmossolle said:
I have a field called rqrdate, I want to add 7 days to it and inset it to a
field called projdate. Could someone please assist?

Thanks!
Click to expand...
Click to expand...
 
Back
Top