Results 1 to 4 of 4

Thread: Help! Help!

  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: Help! Help!

    I have a field ina table that displays the date of an invoice. I need to convert this date to a number (of days the invoice has aged). example: 12/15/2004 = 5 days. can this be done? HELP!!!

  2. #2
    Join Date
    Dec 2004
    Posts
    22

    Easy

    The below query gets data from a table calls, it will show you the data and the number of days that have elapsed since then.

    SELECT calls.CallDate, DateDiff("d",calls.CallDate,Now()) AS Expr1
    FROM calls;

  3. #3
    Join Date
    Nov 2004
    Posts
    22
    If you are like me and are not so savvy with the code, you can create a query that has the invoice date as one of the fields. Then create a new field that calculates the age of the invoice.

    InvoiceAge: =Date()-[InvoiceDate]

    InvoiceAge is the name of the new field. Date() represents the current date. [InvoiceDate] is the name of the field in your table that holds the invoice date.

    Good luck

    Craig
    rockjock

  4. #4
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122
    I used the date diff function- it work!

    thanks everybody for your help and suggestions!

Posting Permissions

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