Forum Discussion
Create a date custom column by file date
Hi everyone, I daily download a .csv file that has no date reference. I'd like to create a custom column that sets the date by the 'file modified date' (or similar). any ideas? Thanks!
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
Is there also any way to get modified/created date out of file when the file is stored in the SharePoint?
Iam connecting to it with powerbi using get data "web"
Hi,
I have the same issue.
I would like to display the creation date of an excel file in my report.
Any idea how to read and display it?
Thanks a lot for helping.
Rob