https://preview.redd.it/085qo7pa8qed1.png?width=1501&format=png&auto=webp&s=2ce4d389ab36f59a4067e825809b25c4c6850966
I've recently learned the "Date" column in a Windows Explorer folder is a calculated field dependent on the type of file that is in a given directory. This is outlined in this article:
https://devblogs.microsoft.com/oldnewthing/20230921-00/?p=108808
I'd like to understand how I can export a listing of the files and their respective "Date" data to an exportable file (preferably Excel, but if not, TXT is fine). To be clear, it's not the "Date created" or "Date modified" columns, I'm looking for the "Date" column. The exported file should have two columns; one column that lists the files and another column that lists the files' respective "Date" data. It's a calculated field, so I don't even know if the Date column is considered a piece of metadata or extended file attribute. There MUST be a way to get this output to a file because Windows shows it.
Forgive my lack of experience, but if PowerShell is the way to get it, can you provide the code/instructions on exactly how to do it and how I can modify it for any given folder and any given column (like "Media Created Date" column), that would be much appreciated!! If there's a program to get this, that would be awesome too!
