1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Update date field

Discussion in 'Business Applications' started by melonhead, Jan 6, 2014.

Thread Status:
Not open for further replies.
Advertisement
  1. melonhead

    melonhead Thread Starter

    Joined:
    May 6, 2002
    Messages:
    881
    Thanks in advance for your help!

    I used to know this and I did a search and couldn't find the answer.

    How do you update a field to a date either 6 months away or 12 months away for the current date in that field?

    Thanks again!
     
  2. Sponsor

  3. melonhead

    melonhead Thread Starter

    Joined:
    May 6, 2002
    Messages:
    881
    Oops! Forgot to give you where I was doing the query-Access 2013
     
  4. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,492
    DateAdd('m',6,[dateField1]) will add 6 months
    DateAdd('m',-6,[dateField1]) will subtact 6 months
     
  5. melonhead

    melonhead Thread Starter

    Joined:
    May 6, 2002
    Messages:
    881
    Thank you so much! That does it!
     
  6. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,492
    Glad to here it works for you. Mark the thread 'solved' when you get a chance.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1116917