Hi,
I am combining files from a SharePoint folder that contain aged debtor information. In the source files there is a field "Days overdue" that calculates the number of days a debt has been outstanding. The calculation for this is the number of days between the current date and the original transaction date.
When I combine the files I have noticed that this field is not being updated to use the current date it just shows the calculation as at the last time the file was saved. Is there any way to get this to update when combining the files?
Thanks
Bax
Hi Bax,
I recommend you perform this calculation in Power Query because the Excel formula will only update when the file is opened. You can use:
=DateTime.Date(DateTime.LocalNow())
To get today's date in Power Query.
Mynda
Hi Mynda,
That is the conclusion I came to in the end. I just wondered if there was any other way around it. Something to bear in mind when combining files in the future.
Thanks for getting back on this.
Thanks
Bax
