Results 1 to 3 of 3

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 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    datediff("d", invoiceDate, date())

    see datediff in A-help

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122
    Thanks!!!
    That worked!!!!


    Thanks!

Posting Permissions

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