Batch file – Get Filenames & Timestamps

Issue

Can anyone help me create a batch file that will display all the files, subfolders and files under subfolders of folder with both date created and date modified then output the result to .txt or .xls file.

Here's what I've tried but I cannot display both date created and date modified.

dir /t:c /t:w /s /q "C:\Documents and Settings\administrator\Desktop\fileinfo_test" >> "C:\Documents and Settings\administrator\Desktop\dir.txt" 

Solution

Here it is:

DIR [drive:][path][filename] [/A[[:]attributes]] /B /C /D /L /N 
[/O[[:]sortorder]] /P /Q /S [/T[[:]timefield]] /W /X /4 

[drive:][path][filename] 

Specifies drive, directory, and/or files to list.

/A- Displays files with specified attributes.
attributes D Directories R Read-only files
H - Hidden files A Files ready for archiving
S - System files - Prefix meaning not
/B - Uses bare format (no heading information or summary).
/C - Display the thousand separator in file sizes. This is the
default. Use /-C to disable display of separator.
/D - Same as wide but files are list sorted by column.
/L - Uses lowercase.
/N - New long list format where filenames are on the far right.
/O - List by files in sorted order.
sortorder N By name (alphabetic) S By size (smallest first)
E - By extension (alphabetic) D By date/time (oldest first)
G - Group directories first - Prefix to reverse order
/P - Pauses after each screenful of information.
/Q - Display the owner of the file.
/S - Displays files in specified directory and all subdirectories.
/T - Controls which time field displayed or used for sorting
timefield C Creation
A - Last Access
W - Last Written
/W - Uses wide list format.
/X - This displays the short names generated for non-8dot3 file
names. The format is that of /N with the short name inserted
before the long name. If no short name is present, blanks are
displayed in its place.
/4 - Displays four-digit years

Switches may be preset in the DIRCMD environment variable. Override
preset switches by prefixing any switch with - (hyphen)--for example, /-W.

============================================================ ======

dir "D:\Documents and Settings\dave\Desktop\"/T:C /T:W /S /Q >> "d:\Documents and 

Settings\dave\Desktop\dir.txt" 

This will produce the desired result. (you need to put the switches after the source details).

Note

Thanks to sharpman for this tip on the forum.