Having trouble with formatting months and days as "MM" and "dd"

[RyLH87]

Hi all,

I'm new to this forum, and was wondering if anyone can help me with the following.

I am trying to write some code that will return the Month and Day of a given date in the format "MM" and "dd" respectively, e.g. 06 14 for June 14th. So far I have the below, but this does not work. The month value returned is 01 instead of 06 and the day value returned is 13 instead of 14.

The value of ExDate is 06/14/2013.

Please Login or Register  to view this content.

The reason why I'm trying to achieve this is because I am trying to open a file with "2013 06 14" on the end of the file name.

Any ideas of how I can solve this would be much appreciated.

Thanks,

Ryan

[JosephP]

replace

Please Login or Register  to view this content.

by simply

Please Login or Register  to view this content.

[RyLH87]

Ah, thanks JP!

I knew it would be something simple, but couldn't quite figure it out.

I further simplified the whole thing to:

Please Login or Register  to view this content.

Thanks for the quick reply.