"Pegasus [MVP]" <news@newsgroup> wrote in
> "Davy" <me@newsgroup> said this in news item
>> I have files whose filenames include date created; with the
>> format ddmmmfilename2, ddmmmfilename3, etc in a folder.
>> In Windows Explorer I want to view the files in date sequence. How
>> can I manipulate the ddmmm into a format that can be logically
> Since you specifically mention Windows Explorer, I think you're
> posting in the wrong group. This group focuses on VB Scripting. A
> Windows XP (?) or a Windows file system newsgroup may be a better
> place. Anyway, since you named your files ddmmmFilename you have
> options: - Sort by dd (which is probably useless)
> - Sort by file date, by clicking the file date column header in
> Explorer. - Rename the files to yyyymmddFilename (where mm is the
> month *number*, not name).
Pegasus, thanks for the prompt reply. I now realise that my post was
not as clear as I imagined.
Although I want to use Windows Explorer to view the list of files, I
want to use VBS to rename the files so that they can be sorted
meaningfully by date.
There are too many files to rename manually.
Unfortunately the files' 'date created' property does not reflect the
date created; just the date these files were placed into their current
I realise that I could write some VBS script along the lines of;
if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date
to mmdd so can be meaningfully sorted.
But I had hoped that there might be a VBS function that can parse a
date in the format ddmmm and recognise it and then another function to
convert it to a format that can be put into a file name for sorting.
Hope this makes sense, my VBS knowledge is somewhat limited.