var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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!!!
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
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 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.
I used the date diff function- it work!
thanks everybody for your help and suggestions!