0

Current date in table

Dear All,

I am quite new in Jet Express and I am still exploring the functionality of it. I have prepared an Open Items list from our customers and would like to calcualte the number of days the invoices are past their due date. What I am looking for is a function that adds the current date to a table so I can calculate the days past due. I have prepared a pivot table on top of the table to report. It looks like the Excel function "=Today()" disappears when the table is refreshed. Does anyone know a solution?

Regards,
Richard

1 comment

Please sign in to leave a comment.