Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2013
    Posts
    5

    Unanswered: Date calculation

    Hi
    I have a table which collects data of our technical supporter.
    The support has a start date and an End date
    Each supporters have some supports during the year
    I would like to calculate the amount of days passed from last support End date until today
    Could you please help me on that
    Thanks in advance
    Abugilda

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Sear in Access help for the DateAdd() function.
    Have a nice day!

  3. #3
    Join Date
    Sep 2013
    Posts
    5

    date calculation specific

    Hi Thanks
    I know I can use DateAdd or DateDiff
    This will return a value for each and every support
    I would like to have the calculation only from the latest report
    Thanksin advance
    abugilda

  4. #4
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    See DMAX in access and use this to give you the last Support End date and then use DateDiff to give you number of days from the last support date.

  5. #5
    Join Date
    Sep 2013
    Posts
    5

    Date calculations

    Thanks
    Working good
    Itzik

Posting Permissions

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