Aging an invoice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to determine the age of an invoice being able to subtract the
[InvoiceDate] from the current date and display the information on a daily
report. What is the best way to go about this?
 
Date() would probably be better than Now(), as it does not take the time of
day into account. Now() is likely to produce a number with lots of decimal
places. The Int function could be used together with Now() to produce the
whole number, but there's no need for the extra step.
DateDiff could also be used:
DateDiff("d",[InvoiceDate],Date())
Just to clarify another point, the OP should create an unbound control, not
a field. I expect that's what you meant, but it seems best to be specific
about the point.

Kyle said:
Create a feild on your report and use this expression =Now() -
[InvoiceDate].
DMainland said:
I would like to determine the age of an invoice being able to subtract
the
[InvoiceDate] from the current date and display the information on a
daily
report. What is the best way to go about this?
Click to expand...
Click to expand...
 
Back
Top