formatting datetime field

[djc]

one of the columns in my asp.net datagrid shows a datetime value from an sql
server. By default is displays the date like this "mm/dd/yyyy hh:mm:ss am"
or the same ending in 'pm'. How do I make it only show the 'mm/dd/yyyy'
portion? Should I do this within asp.net/vb.net or should it be done
somewhere in the query that returns the data first?

any info would be appreciated. Thanks.

[Curt_C [MVP]]

..ToShortDate() is what I believe you are after.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"djc" <no***@nowhere.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

one of the columns in my asp.net datagrid shows a datetime value from an
sql
server. By default is displays the date like this "mm/dd/yyyy hh:mm:ss am"
or the same ending in 'pm'. How do I make it only show the 'mm/dd/yyyy'
portion? Should I do this within asp.net/vb.net or should it be done
somewhere in the query that returns the data first?

any info would be appreciated. Thanks.

[djc]

Thanks.

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:ua**************@TK2MSFTNGP14.phx.gbl...

.ToShortDate() is what I believe you are after.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"djc" <no***@nowhere.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

one of the columns in my asp.net datagrid shows a datetime value from an
sql
server. By default is displays the date like this "mm/dd/yyyy hh:mm:ss am" or the same ending in 'pm'. How do I make it only show the 'mm/dd/yyyy'
portion? Should I do this within asp.net/vb.net or should it be done
somewhere in the query that returns the data first?

any info would be appreciated. Thanks.