DTS : Format Problem !

I have a statement in the DTS ( Activex Script ) like this :

TomorrowDate = Format$(Now, "yyyy-mm-dd")

When i am running the package, i am getting the following error :

ActiveX Script Task: undefined

Error Code: 0

Error Source= Microsoft VBScript compilation error

Error Description: Invalid character

Error on Line 8

Can anyone tell me what is the solution to this error ?

Thanks in advance.

Remove the $ in Format$

-Vijay

|||

Hi vijay,

Thanks. Even when i removed $ from format, still an error :

Telling that :

Type Mismatch "Format"