Date Format in expression

Hi all,

I would like to generate a file name according to the current date, like 20070716.TXT. In expression, the function Month(Getdate()) will return 7 instead of 07.

How can i do it.

TIA

Patrick

Try this... Going by memory.

RIGHT("00" + (DT_WSTR,50)MONTH([DateColumn])),2)

|||

Start for using this...

=Format(cdate(Fields!Dia.Value),"dd-MM-yyyy")

and concactenate with string you want!!

regards

|||

PedroCGD wrote:

Start for using this...

=Format(cdate(Fields!Dia.Value),"dd-MM-yyyy")

and concactenate with string you want!!

regards

In SSIS? Looks like Excel or something to me.