User Profile

Collapse

Profile Sidebar

Collapse
eastbat
eastbat
Last Activity: Dec 14 '11, 09:14 AM
Joined: Dec 14 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • eastbat
    replied to calculate end date from start date
    in Access
    Hi Sierra7

    It's absolutely PERFECT !!!
    Thank you very much.
    See more | Go to post

      Leave a comment:

    • eastbat
      started a topic calculate end date from start date
      in Access

      calculate end date from start date

      Hi Everyone,

      I would like to create an [end date] from the [start date]in ms access form.
      The formula is simple :([start date] + 3month) - (day of the start date-1day)

      for example:
      a.) if the start date is 01.01.2011 than the end date will be 03.31.2011 or

      b.) if the start date is 15.02.2011 than the end date will be 14.05.2011

      I've tried with this DateSerial(Year ([start...
      See more | Go to post
      No activity results to display
      Show More
      Working...