forum.vdsworld.com

[vtol]

Yeah I know.
Like I kept trying to saying before, its not older, its newer
its crazy...
Anyways, sound like your timestamps in Gadget willbe real nice.
Thanks

[Dave Heck]

I apologize for this being a little long-winded, but I've been stumped by this for a couple hours and doing some testing over the last hour or so to make sure of what I'm seeing. I thoght I'd try to save someone else the wasted time.

I believe I have uncovered some of the answers to the date issue/questions posed here although I don’t know if this behavior is by design or possibly considered a bug. I'm working on a routine that will load the contents of a folder into a list, then loop through the list getting the date with the @File function. I need to act upon the files based on the modified date.

The @File function returns different results depending on whether you put quotes around the filename or not. I came across this because some of the files I’m working on are cookies and they have the "@" sign in them. I wanted to be sure the IDE didn't try to interpret the filename as a Function.

Below is the setup, test scripts and results of what I am getting. I have used a file utility to modify the file dates to ensure all 3 dates are different making it possible to determine what date is returned.

SETUP:
Folder C:\Test
File in folder: test.txt
File Create date: Sunday, January 01, 2006, 12:00:00 AM
File Modified date: Monday, January 01, 2007, 12:00:00 AM
File Accessed date: Today, December 07, 2008, 10:51:05 AM

Test Script 1: display “raw” file date value
%%Date_withoutquotes = @FILE(C:\Test\Test.txt,T)
%%Date_withquotes = @FILE(@chr(34)C:\Test\Test.txt@chr(34),T)
INFO "Date without quotes: "%%Date_withoutquotes@CR()"Date with quotes: "%%Date_withquotes
EXIT

Test Script 1 Results:
%%Date_withoutquotes: 39083 (Modified Date value)
%%Date_withquotes returns: NULL


Test Script 2: Use @DateTime to convert the results
%%Date_withoutquotes = @DATETIME(MM/DD/YYYY,@FILE(C:\Test\Test.txt,T))
%%Date_withquotes = @DATETIME(MM/DD/YYYY,@FILE(@chr(34)C:\Test\Test.txt@chr(34),T))
INFO "Date without quotes: "%%Date_withoutquotes@CR()"Date with quotes: "%%Date_withquotes
EXIT

Test Script 2 Results:
%%Date_withoutquotes returns: 01/01/2007 (Modified Date)
%%Date_withquotes returns: 12/07/2008 (Accessed Date)

[SnarlingSheep]