only date part
HI All, I want to get only the date part. Right now it gives both date and time. "\\\\1XX.18.2XX.1X1\\y$\\MyFolder\\" + @[User::FileName]+(DT_WSTR,35) GETDATE() +".xls" so the result would be like this; \\1XX.18.2XX.1X1\y$\MyFolder\MyFileName\2010-12-27.xls shamen
December 28th, 2010 4:49pm

try this: "\\\\1XX.18.2XX.1X1\\y$\\MyFolder\\ " + @[User::FileName]+ (DT_WSTR,4)(year(GETDATE()))+"-"+ RIGHT("0"+(DT_WSTR,2)(month(getdate())),2)+"-"+ RIGHT("0"+(DT_WSTR,2)(day(getdate())),2) +".xls"http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 4:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics