Could you explain what you want to achieve with
rowno() as Recno
WHERE FileTime > '$(vMaxTime)'+0.001;
And with the code that follows that table?
I would have thought that a table load like
Timestamp(max(Filetime)) as ModifiedTime,
FirstSortedValue(Name, -Filetime) as LastModifiedFileName
should return your requested record.
That was code that someone had me try so I am not sure what it does. My goal is to get the latest or max date modified in a folder. If you look at the response above I have a folder called Backups.
each file in the folder has file with *backup and a date modified.
So the folder has 30 backup files and I want the file with the latest edition modified date.
Example of folder
*.backup01 Modified date 2/3/2016
*.backup02 Modifed date 5/16/1016
*.backup03 Modifed date 4/3/2016
*.backup04 Modifed date 3/16/2016
I want the response to return me *.backup02 only since it was the max modified date. I hope this makes since.