query explanation

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

for the formula below - what does the minus 1 (-1) at the
very end of the expression do? what is its purpose? i know
that the 1 in the expression is saying look ahead 1 month
(correct?) but what is the -1 at the very end do?

thanks,
mike


Between #7/1/2003# And #6/30/2004# And DateAdd("m",1,
[first_pymt_due_date])-1
 
Back
Top