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