custom date formats

[Guest]

Hi;

I would like to format a date like this this mmddyy.

I am reading records from a table using the ado.net reader

The dates vary in their length i.e. the day can be either one or two digits
and
the same is true for the month.

I tired the formatDateTime() like :
formatDateTime(rdr2.getvalue(7), dateformat.ShortDate) which yields
mmddyyyy.

The final result that I am looking for is mmddyy.

Do I need a custom date format instead of dateformat.ShortDate ?

Thanks for any insights,

 

[Chris Dunaway]

Hi;

I would like to format a date like this this mmddyy.

I am reading records from a table using the ado.net reader

The dates vary in their length i.e. the day can be either one or two digits
and
the same is true for the month.

I tired the formatDateTime() like :
formatDateTime(rdr2.getvalue(7), dateformat.ShortDate) which yields
mmddyyyy.

The final result that I am looking for is mmddyy.

If you have a DateTime variable, you can use the ToString method to get
the format you want:

Dim strDate As String = DateTime.Now.ToString("MMddyy")

Note the capital M in the format string. Lower case m signifies
"minutes", upper case M signifies month.