Date Order

A

annonymous

I have Folders, which contain monthly files (one file per month) going back
four years. I know how to change the date order in which they are presented
by using the "Modified" function.

Recently I had to examine several month's files from 2001 and now find that
they are out of date order and using the "Modified" function will not get
them into that order, because I did do some alteration in each file.

Is there any other way of getting all the files in a Folder in a date order?
Each file would be described as e.g. ".........-November 2001" and
"........December 2001" etc.etc. Thank you in advance.
 
A

annonymous

Many thanks for the effort, but your suggestions does not solve my problem.
I want the file names, as shown in the example, to be in a date order.

Any other suggestions from anybody?
 
M

Michael Bednarek

Many thanks for the effort, but your suggestions does not solve my problem.
I want the file names, as shown in the example, to be in a date order.

Any other suggestions from anybody?
[snip]

If sorting them by date of creation doesn't do it, consider renaming the
files so that their filenames become date-sortable strings. The obvious
method is to use "yyyymmdd.....". This can be automated from the command
line with a decent shell, or from VBA or VBS code. If changing the
existing filenames would break other applications, you could create a
subdirectory and create the renamed files as hard links there.
 
A

annonymous

Assuming that I rename all the files so that they have consecutive names:
e.g. current File would be named ".....November 2004 and the next one
......December 2004". The renamed Files would have corresponding names
2004.11.30 and 2004.12.31.

What then? There is no option in the various menus to put these files, which
go back to 2001 into a date order, or am I missing something?

Please be more specific in your instructions. Thank you.

Michael Bednarek said:
Many thanks for the effort, but your suggestions does not solve my
problem.
I want the file names, as shown in the example, to be in a date order.

Any other suggestions from anybody?
[snip]

If sorting them by date of creation doesn't do it, consider renaming the
files so that their filenames become date-sortable strings. The obvious
method is to use "yyyymmdd.....". This can be automated from the command
line with a decent shell, or from VBA or VBS code. If changing the
existing filenames would break other applications, you could create a
subdirectory and create the renamed files as hard links there.
 
»

» mrtee «

Inserting a . in a name means that what follows is the file estension, as in .exe your extension would be .11. The file name should be 20040131 to 20041231 earlier years 20010131 to 20031231 then just sort the files in the folder by name. You do need the 0 before months 1/9.

--
Just my 2¢ worth,
Jeff
__________In response to__________
| Assuming that I rename all the files so that they have consecutive names:
| e.g. current File would be named ".....November 2004 and the next one
| .....December 2004". The renamed Files would have corresponding names
| 2004.11.30 and 2004.12.31.
|
| What then? There is no option in the various menus to put these files, which
| go back to 2001 into a date order, or am I missing something?
|
| Please be more specific in your instructions. Thank you.
 
M

Michael Bednarek

Assuming that I rename all the files so that they have consecutive names:
e.g. current File would be named ".....November 2004 and the next one
.....December 2004". The renamed Files would have corresponding names
2004.11.30 and 2004.12.31.

What then? There is no option in the various menus to put these files, which
go back to 2001 into a date order, or am I missing something?

I'm not quite sure what you are saying here. Are we talking about the
presentation of filenames in Windows Explorer? If you rename all the
files according to the scheme
yyyymmdd......ext
where ...... corresponds to the dots in your original post (some sort of
descriptiion, I presume) and ext is the file extension, don't these
filenames then present in the desired order when sorted by filename?
Please be more specific in your instructions. Thank you.

On second thoughts, could you explain why the order is important? And if
it is, you should really spend some time in designing a naming scheme
which will support whatever sorted order you require.
Michael Bednarek said:
Many thanks for the effort, but your suggestions does not solve my
problem.
I want the file names, as shown in the example, to be in a date order.

Any other suggestions from anybody?
[snip]

If sorting them by date of creation doesn't do it, consider renaming the
files so that their filenames become date-sortable strings. The obvious
method is to use "yyyymmdd.....". This can be automated from the command
line with a decent shell, or from VBA or VBS code. If changing the
existing filenames would break other applications, you could create a
subdirectory and create the renamed files as hard links there.
 
A

annonymous

Many thanks. The suggestion you make works fine according to an experiment I
conducted, although I must say that it will take some time to get used to
the new look of file names, but in the end it will be easier to find them
once they are in a proper date order! Thanks again.

Inserting a . in a name means that what follows is the file estension, as in
..exe your extension would be .11. The file name should be 20040131 to
20041231 earlier years 20010131 to 20031231 then just sort the files in the
folder by name. You do need the 0 before months 1/9.

--
Just my 2¢ worth,
Jeff
__________In response to__________
message | Assuming that I rename all the files so that they have consecutive names:
| e.g. current File would be named ".....November 2004 and the next one
| .....December 2004". The renamed Files would have corresponding names
| 2004.11.30 and 2004.12.31.
|
| What then? There is no option in the various menus to put these files,
which
| go back to 2001 into a date order, or am I missing something?
|
| Please be more specific in your instructions. Thank you.
 
B

Bob I

IF you r-click on the header a list of file attribute is presented.
Select "Created Date" so it will be displayed in addition to "Name"
,"Size", "type", "modified" etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top