Adding a number field to a date

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I am looking for a way to take a field formatted as
numbers but representing months, and adding it with a date
(mm/yyyy). In a simple add Access assumes the number
field is days, not months, with a DateAdd [e.g. DateAdd
('mm/yyyy', numberfield, datefield)] yields an error in
the query results. It's probably something simple I'm
missing here...any thoughts? Thank you.
 
To add a number of months, try:
DateAdd("m", [numberfield], [datefield])
 

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

Back
Top