Results 1 to 2 of 2

Thread: Dates

  1. #1
    Join Date
    Dec 2003
    Location
    The Netherlands
    Posts
    98

    Unanswered: Dates

    I have query based on a table in which there is always a start date and sometimes an end date. For those records that have an end date I would like it to say how many days between start and end. For those without an enddate I want it to show how many days between startdate and sysdate.

    Any help is greatly appreciated. THANKS.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Dates

    Originally posted by charlottevk
    I have query based on a table in which there is always a start date and sometimes an end date. For those records that have an end date I would like it to say how many days between start and end. For those without an enddate I want it to show how many days between startdate and sysdate.

    Any help is greatly appreciated. THANKS.
    Look at the DateDiff function ... Ex:

    DateDiff("d",[startdate],iif(isnull([enddate],Date,[Enddate])

Posting Permissions

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