Solved

create file date time windows

Posted on 2014-07-18
11
226 Views
Last Modified: 2014-07-28
Find the latest created file in a directory:
The below command would print the files in the order of creation date & time. In this list the file that is created very recently would be displayed in the last position.

dir /A:-D /T:C /O:D
Example:

C:\>dir /A:-D /T:C /O:D
02/06/2012  07:38 PM                 4 4.txt
02/06/2012  07:39 PM                 0 5.txt
02/06/2012  10:45 PM                13 10.txt
02/06/2012  10:47 PM                13 newfile.t
02/11/2012  08:24 PM                83 2.bat
02/11/2012  08:26 PM             5,219 data.txt
02/11/2012  08:27 PM             5,219 data2.txt
02/12/2012  11:28 PM                98 3.bat
02/13/2012  10:47 AM               131 echo.bat
0
Comment
Question by:gsgi
  • 5
  • 4
11 Comments
 
LVL 13

Assisted Solution

by:duncanb7
duncanb7 earned 200 total points
ID: 40205783
Please take a look at the following code for  DOS command batch file and for reference only ,and it is NOT fully tested

Duncan
@echo off
dir /A:-D /T:C /O:D |find ":">junk.txt
for /f "tokens=1 delims=" %%a in ('type junk.txt') do set newest=%%a
if not "%newest%"=="" echo Latest created file is "%newest%"
del junk.txt

Open in new window

0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40206185
Do you have the tail command available? If so you can do this:
dir /A:-D /T:C /O:D | findstr /r /c:"^[0-9]" | tail -1

Open in new window

The findstr command will filter only lines starting with a number and tail -1 will show you only the last line of that filtered output.

Tail is part of a set of WIn32 ported UNIX tools: http://unxutils.sourceforge.net/
0
 
LVL 13

Author Comment

by:gsgi
ID: 40206538
Thanks Everyone!!!!
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40206572
@gsgi - Did you try the first comment that you've chosen as an answer? I did and I got this as reply:

Latest created file is "07/19/14  09:38 PM                 0 junk.txt"

So I believe you may have chosen the wrong answer, you can ask for attention using the "Request Attention" button above.
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 300 total points
ID: 40206573
If you want to use the first comment as a solution, you need to change the following to make it work:

@echo off
dir /A:-D /T:C /O:D |find ":">%TEMP%\junk.txt
for /f "tokens=1 delims=" %%a in ('type %TEMP%\junk.txt') do set newest=%%a
if not "%newest%"=="" echo Latest created file is "%newest%"
del %TEMP%\junk.txt

Open in new window


The temporary file junk.txt is now moved to %TEMP% - so no target for the script above. If you move the script above to %TEMP% as well and run it from there it is working.

So:

C:\>%TEMP%\findfile.cmd

would give you:

Latest created file is "02/13/2012  10:47 AM               131 echo.bat"

(assuming that your %TEMP% is not equal to C:\)
0
 
LVL 13

Assisted Solution

by:gsgi
gsgi earned 0 total points
ID: 40206581
I didn't because I could read his logic; I assume his .bat file is fixable.  Is there something about his bat file that would not be fixable?   I do not have the tail command.  I try to solve for solutions using native commands when possible.

If we put junk.txt somewhere else does it work?  His .bat file makes a junk.txt file which becomes the latest file.  Here I put junk.txt in c:\

@echo off
dir /A:-D /T:C /O:D |find ":"> c:\junk.txt
for /f "tokens=1 delims=" %%a in ('type c:\junk.txt') do set newest=%%a
if not "%newest%"=="" echo Latest created file is "%newest%"
del junk.txt

The other way to fix this is to have it cycle through all but the last file in the listing.

-gsgi
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40206584
See my comment above, all needed corrections are there. I tested and it worked.
0
 
LVL 13

Author Comment

by:gsgi
ID: 40206599
Would this work - I am not a .bat file scripter so my syntax is probably wrong...  By using temporary for the last line of the listing and setting newest to temporary each time through the loop, newest becomes the 2nd to last filename in the listing, so we do not grab junk.txt

@echo off
dir /A:-D /T:C /O:D |find ":">junk.txt
set temporary=""
for /f "tokens=1 delims=" %%a in ('type junk.txt') do {set newest=temporary set temporary=%%aa}
if not "%newest%"=="" echo Latest created file is "%newest%"
del junk.txt

-gsgi
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40206630
The idea is good, with some more modifications, this is working as long as you don't have the script in the folder where you run it:
@echo off
SETLOCAL EnableDelayedExpansion
dir /A:-D /T:C /O:D |find ":">junk.txt
set temporary=""
for /f "tokens=1 delims=" %%a in ('type junk.txt') do set newest=!temporary! && set temporary=%%a
if not "%newest%"=="" echo Latest created file is "%newest%"
del junk.txt

Open in new window


but my suggestion above in http:#a40206573 is working as well.
0
 
LVL 13

Author Closing Comment

by:gsgi
ID: 40223684
Thanks for participating in this question.  I originally selected duncanb7 as the best answer because I could follow his thinking and his answer used no extra tools or utilities.  Gerwin Jansen wrote to me asking why I would select an answer that did not work as the best solution and he fixed the solution so that it works.  To properly represent correct code in the EE database, I am changing the best answer to Gerwin Jansen's fix for the code originally offered by duncanb7.  Thanks, gsgi
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: I have always been a big fan of Windows but my liking towards it is slowly being eroded by the variety of other Applications that I encounter, when I browse the Web. Most of the software available is free and maybe Open Source too. …
Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question