Hi All,

I think this is an easy question.

I've a date field (pulled from db) that has the time with it:

6/25/1969 12:00:00 AM
12/25/1969 12:00:00 AM

I would like to just extract the mm/dd/yyyy,
so it would look like this:

6/25/1969
12/25/1969

Any ideas? Thanks in advance !

Nevermind, I figured it out.

If you're wondering, you can do it in 2 ways:

in your T-SQL script, use the convert function:
Convert(Char(10),datestring,101)

Or in vb.net, use the following statements:
'strDate returns desire format
    Dim strDate as String
    strDate = String.Format("{0:dd/MM/yyyy}", CType(DtDate, Date))

You can also do it in .Net like this:

FormatDateTime([DateToFormat], DateFormat.ShortDate)

J