Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    3

    Question Unanswered: Date Calculations Help

    I am using the following formula in a form (=DateSerial(Year([ref_decision_date]),Month([ref_decision_date]),Day([ref_decision_date])+14)) and it works fine to display the result in the form, but i want the resulting date to also be displayed in the table. I have tried to copy the formula to the table properties but it will not work. Does anyone have any ideas?


  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372

    Hello Tony!

    Link your field with field in Table, and this code put in
    VBA Sub "form_BeforeUpdate".

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    2 thoughts. First, if this date is always 14 days after the first date, you shouldn't store it. Simply calculate it when you need it. Second, you might find the DateAdd function simpler than DateSerial.
    Paul

Posting Permissions

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