I am having an issue with a date to text function. At least thats what i think it is (I dont know a great deal about FM.)

We use the script Middle(DateToText(Today,7,1) & Middle(DateToText(Today,8,2) to make the begining part of our Folder Numbers. Which would result in something like this 911 (9=2009, 11=Month # NOVEMBER)

HOWEVER since it has turned 2010, it has changed to 001 Which seems right, BUT that was the very first Folder Number when we first started this program. We are receiving an error that says this folder number is a duplicate. Which it is...

SO! My questions is how do I make it for 2010? Do I need to have four characters sintead of 3 like such "911", so instead it would be "0911"?

Please Help! I know its an old version, but is someone out there?? =0) Thanks in advance!

The Today Function goes away in v7 and newer, so you should change these calculations to use Status CurrentDate. The Status Functions will convert cleanly to Get Functions in v7 and newer.

How about something like

Right( Year( Status(CurrentDate)) , 2 ) & Right(00 & Month(Status(CurrentDate)) , 2 )