Dukester0122
IS-IT--Management
I need a formula that would show how old our invoices are based on number of days. Example, Invoice001 was created 01/01/2004 then today is 03/15/2004, so Invoice001 is 75 days old.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting Days old 1
- Thread starter Dukester0122
- Start date
- Status
-
1
- #2
Create a formula and just subtract the 2 dates.
//@Days Old
currentdate - {table.invoice_date}
Second way to do it is to use the DateDiff function
//@Days Old
datediff("d",{table.invoice_date},currentdate)
Both of these will return integers representing the number of days difference between a date field and today
~Brian
//@Days Old
currentdate - {table.invoice_date}
Second way to do it is to use the DateDiff function
//@Days Old
datediff("d",{table.invoice_date},currentdate)
Both of these will return integers representing the number of days difference between a date field and today
~Brian
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question