I have files whose filenames include date created; with the filename 
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 sorted?

thanks

Davy

"Davy" <me@removeallthistextchobham.org.uk> said this in news item 
news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145...
> I have files whose filenames include date created; with the filename
> 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 sorted?
>
> thanks
>
> Davy

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 three 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 [MVP]" <news@microsoft.com> wrote in
news:#I8TjnKjKHA.4048@TK2MSFTNGP06.phx.gbl: 

> "Davy" <me@removeallthistextchobham.org.uk> said this in news item 
> news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145...
>> I have files whose filenames include date created; with the 
filename
>> 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
>> sorted? 
>>
>> thanks
>>
>> Davy
> 
> 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 
three
> 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 
context.
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.

cheers, DAvy

"Davy" <me@removeallthistextchobham.org.uk> said this in news item 
news:Xns9CF6622D5830Fmeremoveallthistextc@216.196.109.145...
> "Pegasus [MVP]" <news@microsoft.com> wrote in
> news:#I8TjnKjKHA.4048@TK2MSFTNGP06.phx.gbl:
>
>> "Davy" <me@removeallthistextchobham.org.uk> said this in news item
>> news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145...
>>> I have files whose filenames include date created; with the
> filename
>>> 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
>>> sorted?
>>>
>>> thanks
>>>
>>> Davy
>>
>> 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
> three
>> 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
> context.
> 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.
>
> cheers, DAvy

OK, I got misled by your subject line. It seems you wish to "rename" rather 
than to "sort" your files. If you put the words "bulk rename" into a Google 
search box then you will get a large number of hits for renaming tools, many 
of the free. Some might actually do exactly what you want to do.

If you can't find one then the File System Object has methods to do this. 
The following code fragment illustrates the concept:
Set oFSO = CreateObject("Scripting.FileSystemObject")
dDate = oFSO.GetFile("d:\tools\att.vbs").DateLastModified
WScript.Echo Year(dDate), Month(dDate), Day(dDate)

You would need to write a script that enumerates every file in the folder 
and renames it with the rename method of the File System Object. Remember to 
pad your days and months with a leading zero if necessary and to deal with 
the case where two files might get the same name. 

"Pegasus [MVP]" <news@microsoft.com> wrote in
news:OZaEAhSjKHA.5604@TK2MSFTNGP04.phx.gbl: 

> "Davy" <me@removeallthistextchobham.org.uk> said this in news item 
> news:Xns9CF6622D5830Fmeremoveallthistextc@216.196.109.145...
>> "Pegasus [MVP]" <news@microsoft.com> wrote in
>> news:#I8TjnKjKHA.4048@TK2MSFTNGP06.phx.gbl:
>>
>>> "Davy" <me@removeallthistextchobham.org.uk> said this in news item
>>> news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145...
>>>> I have files whose filenames include date created; with the
>> filename
>>>> 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
>>>> sorted?
>>>>
>>>> thanks
>>>>
>>>> Davy
>>>
>>> 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
>> three
>>> 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 context.
>> 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.
>>
>> cheers, DAvy
> 
> OK, I got misled by your subject line. It seems you wish to "rename"
> rather than to "sort" your files. If you put the words "bulk rename"
> into a Google search box then you will get a large number of hits 
for
> renaming tools, many of the free. Some might actually do exactly 
what
> you want to do. 
> 
> If you can't find one then the File System Object has methods to do
> this. The following code fragment illustrates the concept:
> Set oFSO = CreateObject("Scripting.FileSystemObject")
> dDate = oFSO.GetFile("d:\tools\att.vbs").DateLastModified
> WScript.Echo Year(dDate), Month(dDate), Day(dDate)
> 
> You would need to write a script that enumerates every file in the
> folder and renames it with the rename method of the File System
> Object. Remember to pad your days and months with a leading zero if
> necessary and to deal with the case where two files might get the 
same
> name. 
> 
> 

Pegasus, thanks for the suggestions.
I have several file-renaming pieces of software - non of which have 
sufficient logic to do what I want.
Regarding your code fragment; the DateLastModified is useless to me 
since I need the date of original creation of the file; which is 
recorded in the filename in the format ddmmmfilename1 etc.

So I need to take the ddmmm part of the filename and re-insert it back 
into the file name in the format mmddfilename1 etc. Obviously I can do 
this with some clumsy manipulation along the lines of:
if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date

but I was hoping to find out if there was some clever date recognition 
function in VBS

cheeers

DAvy

Davy wrote:
> "Pegasus [MVP]" <news@microsoft.com> wrote in
> news:OZaEAhSjKHA.5604@TK2MSFTNGP04.phx.gbl:
>
>> "Davy" <me@removeallthistextchobham.org.uk> said this in news item
>> news:Xns9CF6622D5830Fmeremoveallthistextc@216.196.109.145...
>>> "Pegasus [MVP]" <news@microsoft.com> wrote in
>>> news:#I8TjnKjKHA.4048@TK2MSFTNGP06.phx.gbl:
>>>
>>>> "Davy" <me@removeallthistextchobham.org.uk> said this in news item
>>>> news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145...
>>>>> I have files whose filenames include date created; with the
>>>>> filename 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
>>>>> sorted?
>>>>>
>>>>> thanks
>>>>>
>>>>> Davy
>>>>
>>>> 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
>>>> three 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 context.
>>> 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.
>>>
>>> cheers, DAvy
>>
>> OK, I got misled by your subject line. It seems you wish to "rename"
>> rather than to "sort" your files. If you put the words "bulk rename"
>> into a Google search box then you will get a large number of hits for
>> renaming tools, many of the free. Some might actually do exactly what
>> you want to do.
>>
>> If you can't find one then the File System Object has methods to do
>> this. The following code fragment illustrates the concept:
>> Set oFSO = CreateObject("Scripting.FileSystemObject")
>> dDate = oFSO.GetFile("d:\tools\att.vbs").DateLastModified
>> WScript.Echo Year(dDate), Month(dDate), Day(dDate)
>>
>> You would need to write a script that enumerates every file in the
>> folder and renames it with the rename method of the File System
>> Object. Remember to pad your days and months with a leading zero if
>> necessary and to deal with the case where two files might get the
>> same name.
>>
>>
>
> Pegasus, thanks for the suggestions.
> I have several file-renaming pieces of software - non of which have
> sufficient logic to do what I want.
> Regarding your code fragment; the DateLastModified is useless to me
> since I need the date of original creation of the file; which is
> recorded in the filename in the format ddmmmfilename1 etc.
>
> So I need to take the ddmmm part of the filename and re-insert it back
> into the file name in the format mmddfilename1 etc. Obviously I can do
> this with some clumsy manipulation along the lines of:
> if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date
>
> but I was hoping to find out if there was some clever date recognition
> function in VBS
>
Nope. You're on your own there. But it isn't that hard given that the namers 
of the files were faithful to this format. Simple string functions (Mid, 
Right and Left) will carry you through.

-- 
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM" 

"Davy" <me@removeallthistextchobham.org.uk> said this in news item 
news:Xns9CF6708FE96ACmeremoveallthistextc@216.196.109.145...
> "Pegasus [MVP]" <news@microsoft.com> wrote in
> news:OZaEAhSjKHA.5604@TK2MSFTNGP04.phx.gbl:
>
>> "Davy" <me@removeallthistextchobham.org.uk> said this in news item
>> news:Xns9CF6622D5830Fmeremoveallthistextc@216.196.109.145...
>>> "Pegasus [MVP]" <news@microsoft.com> wrote in
>>> news:#I8TjnKjKHA.4048@TK2MSFTNGP06.phx.gbl:
>>>
>>>> "Davy" <me@removeallthistextchobham.org.uk> said this in news item
>>>> news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145...
>>>>> I have files whose filenames include date created; with the
>>> filename
>>>>> 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
>>>>> sorted?
>>>>>
>>>>> thanks
>>>>>
>>>>> Davy
>>>>
>>>> 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
>>> three
>>>> 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 context.
>>> 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.
>>>
>>> cheers, DAvy
>>
>> OK, I got misled by your subject line. It seems you wish to "rename"
>> rather than to "sort" your files. If you put the words "bulk rename"
>> into a Google search box then you will get a large number of hits
> for
>> renaming tools, many of the free. Some might actually do exactly
> what
>> you want to do.
>>
>> If you can't find one then the File System Object has methods to do
>> this. The following code fragment illustrates the concept:
>> Set oFSO = CreateObject("Scripting.FileSystemObject")
>> dDate = oFSO.GetFile("d:\tools\att.vbs").DateLastModified
>> WScript.Echo Year(dDate), Month(dDate), Day(dDate)
>>
>> You would need to write a script that enumerates every file in the
>> folder and renames it with the rename method of the File System
>> Object. Remember to pad your days and months with a leading zero if
>> necessary and to deal with the case where two files might get the
> same
>> name.
>>
>>
>
> Pegasus, thanks for the suggestions.
> I have several file-renaming pieces of software - non of which have
> sufficient logic to do what I want.
> Regarding your code fragment; the DateLastModified is useless to me
> since I need the date of original creation of the file; which is
> recorded in the filename in the format ddmmmfilename1 etc.
>
> So I need to take the ddmmm part of the filename and re-insert it back
> into the file name in the format mmddfilename1 etc. Obviously I can do
> this with some clumsy manipulation along the lines of:
> if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date
>
> but I was hoping to find out if there was some clever date recognition
> function in VBS
>
> cheeers
>
> DAvy

There are three date methods in the File System Object:
- DateLastModified
- DateLastAccessed
- DateCreated

I recommend you download the helpfile script56.chm from the Microsoft site 
to see the full details.

Depending on your exact setup you could also extract the day and month from 
the file name and the year from the DateCreated method. Translating month 
names into numbers is as clumsy or as elegant as you make it, e.g. like so:

Set dicMonths = CreateObject( "Scripting.Dictionary" )
aMonths = Split(LCase(" Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec"))
For i = 1 To 12
	if i < 10 then x = "0" & i Else x = i
	dicMonths.Add aMonths(i), x
Next
WScript.Echo "Month number = ", dicMonths(LCase("Mar"))
 

Davy wrote:
> So I need to take the ddmmm part of the filename and re-insert it back
> into the file name in the format mmddfilename1 etc. Obviously I can do
> this with some clumsy manipulation along the lines of:
> if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date
>
> but I was hoping to find out if there was some clever date recognition
> function in VBS

You will have to create your own function. Feed the function an original
filename. Use the Mid function to extract the month and convert it to
numerals. Then construct the new name and return it to the function.

Function ddmmm2mmdd(filename)
  mm = Right("0" & Month(Mid(filename, 3, 3) & "/1/00"), 2)
  ddmmm2mmdd = Left(filename, 2) & mm & Mid(filename, 6)
End Function

Now you simply use the new function in a loop.

f.Name = ddmmm2mmdd(f.Name)

-- 
Todd Vargo
(Post questions to group only. Remove "z" to email personal messages)

Todd Vargo wrote:
> Davy wrote:
> > So I need to take the ddmmm part of the filename and re-insert it back
> > into the file name in the format mmddfilename1 etc. Obviously I can do
> > this with some clumsy manipulation along the lines of:
> > if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date
> >
> > but I was hoping to find out if there was some clever date recognition
> > function in VBS
> 
> You will have to create your own function. Feed the function an original
> filename. Use the Mid function to extract the month and convert it to
> numerals. Then construct the new name and return it to the function.
> 
> Function ddmmm2mmdd(filename)
>   mm = Right("0" & Month(Mid(filename, 3, 3) & "/1/00"), 2)
>   ddmmm2mmdd = Left(filename, 2) & mm & Mid(filename, 6)

Oops, I forgot to move the month to the front of the filename.
Replace line above with this line.

  ddmmm2mmdd = mm & Left(filename, 2) & Mid(filename, 6)


> End Function
> 
> Now you simply use the new function in a loop.
> 
> f.Name = ddmmm2mmdd(f.Name)
> 
> -- 
> Todd Vargo
> (Post questions to group only. Remove "z" to email personal messages)
> 

Davy <me@removeallthistextchobham.org.uk> wrote in 
news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145:

> I have files whose filenames include date created; with the filename 
> 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 sorted?
> 
> thanks
> 
> Davy

Thanks guys for the suggestions; look elegant enough for me. I was 
expecting to write reams of 'if' statements...

I compromised with:

		Select Case dMonth
			Case "Jan"
				dMonth = "01"
			Case "Feb" 
				dMonth = "02"
etc

thanks

DAvy

> I compromised with:
>
> Select Case dMonth
> Case "Jan"
> dMonth = "01"
> Case "Feb"
> dMonth = "02"
> etc
>

    This is really just a matter of personal taste,
but if it were me I think I'd just change that to
a day-of-year method, and not even bother with
worrying about month lengths. Just add
(month x 31) + day-of-month to get a unique
number and add that to the file name.
  So 01FebAtTheLake.jpg becomes something
like 32-01FebAtTheLake.jpg. The files can then
be sorted in Explorer by name.

In microsoft.public.scripting.vbscript message <Xns9CF6708FE96ACmeremove
allthistextc@216.196.109.145>, Mon, 4 Jan 2010 05:03:51, Davy <me@remove
allthistextchobham.org.uk> posted:
>So I need to take the ddmmm part of the filename and re-insert it back
>into the file name in the format mmddfilename1 etc. Obviously I can do
>this with some clumsy manipulation along the lines of:
>if mmm is 'Dec' then replace with '12', etc, etc. Then reformat date
>
>but I was hoping to find out if there was some clever date recognition
>function in VBS

Cleverness is not really required.  Consider :

Name = "12Marfilename2"
document.write CDate(Left(Name, 2) & " " + Mid(Name, 3, 3) & " 2000")

document.write because I test in a Web page; use WScript.echo in WSH.

That gives me "2000-03-12", because my WinXP system is set to use ISO
8601 dates.

The result of CDate can if you like be used as an argument for functions
year month day, if you cannot use ISO dates for their obvious advantages
(anything that sensible is Politically Incorrect between Canada &
Mexico, where you are apparently not) but use the European dd.mm.yyyy
with some separator, then you can dissect and reassemble the result of
CDate into Y M D order.

If you use one-digit dates before the 10th of the month (unwise), then
test the second character of the filename to recognise those and treat
accordingly.

                Caveat DatePart for Week Number as used
                in standards-respecting countries.

                                Chobham is not so far from here; watch
                                out for large cylinders falling nearby.

-- 
 (c) John Stockton, nr London, UK.    ?@merlyn.demon.co.uk     Turnpike v6.05.
 Web  <URL:http://www.merlyn.demon.co.uk/> - w. FAQish topics, links, acronyms
 PAS EXE etc : <URL:http://www.merlyn.demon.co.uk/programs/> - see 00index.htm
 Dates - miscdate.htm estrdate.htm js-dates.htm pas-time.htm critdate.htm etc.

Davy wrote:
> Davy <me@removeallthistextchobham.org.uk> wrote in
> news:Xns9CF5B1C1ADEC1meremoveallthistextc@216.196.109.145:
>
> > I have files whose filenames include date created; with the filename
> > 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 sorted?
> >
> > thanks
> >
> > Davy
>
> Thanks guys for the suggestions; look elegant enough for me. I was
> expecting to write reams of 'if' statements...
>
> I compromised with:
>
> Select Case dMonth
> Case "Jan"
> dMonth = "01"
> Case "Feb"
> dMonth = "02"
> etc

Note, this method is case sensitive. Without modification, it will fail if
dMonth is jan or JAN, etc. The function that I posted yesterday changes
ddmmmfilename2 to mmddfilename2. Give it a try.

-- 
Todd Vargo
(Post questions to group only. Remove "z" to email personal messages)