Windows 10 CMD Function

I want a CMD line that will output the contents of a Drive, all Folder and recursive sub-folder(d) and filenames into a .CSV file. The output must be able to be sorted by DATE in Excel, also, the DATE must be the last WRITTEN / MODIFIED date.

Suggested .CSV format headers:

DATE, DRIVE, DIR, FOLDER, SUB-FOLDER(s), FILENAME

I've tried:
C:\Users>dir /a/s/od "cmd /c echo @fdate, @isdir, @file" >Craigtest1.csv
File Not Found

C:\Users>dir /a/s/od "cmd /c echo @fdate, @isdir, @file" > Craigtest1.csv
File Not Found

C:\Users>dir /a/s/od > Craigtest.txt

C:\Users>dir /a/s/od | out-file -filepath c:\path\to\Users\Craigtest.txt

C:\Users>forfiles /s /C "cmd /c echo @file, @fdate, @ftime, @isdir" > MyTextOutput.csv

None of the above work in the required way. See the attached .txt for what I require.