Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Date Question (Office XP Pro)

    How can I turn data like "the first Monday in August" into a date like 8/2/2004? Also, how do I add a number of days from a field to a date field? For example I have a date field that contains a purchase date for a policy. Another field contains a renewal cycle number. How can I make the renewal cycle number add to the purchase date and result in a new renewal date that is the renewal cycle number of days in the future?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Date Question (Office XP Pro)

    Don't know about the first question.

    For the second question: dates are stored internally as days plus fractional days. Therefore, you can do conventional arithmetic on date values simply by adding the two values together. The resulting number can be formatted to appear as a date, or it can be formatted to appear as a number.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

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

    Re: Access Date Question (Office XP Pro)

    For the first question, see the DayInMonth function in <post#=425188>post 425188</post#>. To get the first Monday in August, 2004, use DayInMonth(2004, 8, 2, 1)

Posting Permissions

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