Home All Groups Group Topic Archive Search About
Author
7 Nov 2006 9:18 PM
Gordon
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

Author
7 Nov 2006 9:32 PM
Chris Dunaway
Gordon wrote:
Show quoteHide quote
> 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.