custom date formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
Gordon said:
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.
Click to expand...
The final result that I am looking for is mmddyy.
Click to expand...

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.
 
Back
Top