topic Re: How to make JSL get file timestamp? in Discussions

How to make JSL get file timestamp?

djhanson — Thu, 15 Sep 2011 15:24:59 GMT

Anyone know of any code say utilizing the JSL DLL features to get a file's date/timestamp? For example, get the timestamp for: "C:\mytest.jmp". thx... dj

Re: How to make JSL get file timestamp?

carole — Wed, 28 Sep 2011 13:48:54 GMT

I don't know if it's a solution for you but I propose the following jsl :

strPathFile = "C:\mytest.jmp";

//Save batch file to get date file : create DateFile.txt containing date

Save Text File(

"C:\GetDate.bat",

"for %%x in ("||strPathFile||") do echo datetime=%%~tx >> C:\DateFile.txt";

);

//Launch batch file

Open("C:\GetDate.bat");

wait(1);//wait to let time running batch file

//Open DateFile.txt containing date file in a jmp data table

Open("C:\DateFile.txt",

columns( c000001 = Character ),

Import Settings(

End Of Line( CRLF, CR, LF ),

End Of Field( Comma ),

Strip Quotes( 1 ),

Use Apostrophe as Quotation Mark( 0 ),

Scan Whole File( 1 ),

Treat empty columns as numeric( 0 ),

Labels( 0 ),

Column Names Start( 1 ),

Data Starts( 1 ),

Lines To Read( All ),

Year Rule( "10-90" )

)

);

How to make JSL get file timestamp?

djhanson — Wed, 28 Sep 2011 14:50:49 GMT

Excellent! That seems to do the trick:). Thanks Carole!!!

Re: How to make JSL get file timestamp?

vkessler — Wed, 12 Dec 2018 17:17:41 GMT

Check this out:

timestamp = Creation Date( filePath );

Re: How to make JSL get file timestamp?

TomF — Fri, 15 Nov 2024 16:49:40 GMT

If anyone landed here like I did, looking for the other file timestamp, I was able to get it with a related function:

timestamp = Last Modification Date( filePath );