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.
Greg_Deckler
Community Champion
Community ChampionOK, this is just a working theory, but if you use a Folder query, you can get the last modified date. So I'm thinking that perhaps creating a custom function where you grabe the "Date Modified" from a folder query wrapped in your function that you could return this back as a value for a custom column in the query. Perhaps ImkeF has a better way, she is the M code expert.