• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2457
  • Last Modified:

Trim out date from SQL datetime in VB.NET

If I have a value coming back in SQL Server Reporting Services 2005 Report, what VB.NET Function can I use to trim out just the date portion.  Example value: 2005-02-05 00:00:00

the CDate function doesn't help, so what type of TRIM can I do to accomplish this
0
dba123
Asked:
dba123
1 Solution
 
bisonfur37Commented:
CDate("2005-02-05 00:00:00").ToString("yyyy-MM-dd")
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now