Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically placing a date into a field (2000)

    Is it possible to automatically put a date 7 days from a date into a specified field?
    i.e If the Reminder Sent field date is 07/04/05 is it possible to automatically put a date into the Date field 7 days from this date?
    see attachment for example of what l am trying to acheive.

    Justin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatically placing a date into a field (2000)

    Should the date ALWAYS be7 days after the reminder date, or should the user be able to modify the date afterwards?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically placing a date into a field (200

    The date specified should always be 7 days after the specified date.

    Justin.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatically placing a date into a field (200

    In that case, you don't need a separate date field in the table. Instead, create a query based on the table and add a calculated column:

    Date: [Reminder Sent]+7

    Use this query as record source for forms and reports, and to build other queries on.

    Note: I recommend giving the Date field another name. It can lead to confusion since Date is also a built-in VBA function returning the current date.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically placing a date into a field (200

    Thats great thanks

    Justin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •