How to get the Current date in YYYYMMDD format in Script Task using VB.NET?
How to get the Current date in YYYYMMDD format in Script Task using VB.NET?
Tried with this but no luck
Format(DateTime.Today,
"yyyymmdd"
)
June 28th, 2011 5:12pm
Try the following (note the uppercase MM to denote month instead of minute):
DateTime.Now.ToString("yyyyMMdd")
Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 6:03pm
It worked.Thanks.
June 29th, 2011 9:30am