>I'm trying to create a file name with the current month and day in the file name and need to force leading zeros for the month and day. I tried "TRANSFORM", but it didn't work. Any suggestions?
>
>Thanks,
>
>Harry

You can use PADL() function

lcFileName = "file" + PADL( DAY( DATE()), 2, "0") + PADL( MONTH( DATE()), 2, "0")