Convert DateTime to a specified Format

Question

I have this date format yy/MM/dd HH:mm:ss ex: 12/02/21 10:56:09. The problem is, when i try to convert it to different format using this code:

CDate("12/02/21 10:56:09").ToString("MMM. dd, yyyy HH:mm:ss")

It displays Dec. 12, 2021 10:56:09.

How can i correctly format it to: Feb. 21, 2012 10:56:09? This format is returned when i check balance inquiry fro my SMS based application.

Solution 1

Use DateTime.ParseExact, e.g.:

DateTime.ParseExact("12/02/21 10:56:09", "yy/MM/dd HH:mm:ss", 
    CultureInfo.InvariantCulture
    ).ToString("MMM. dd, yyyy HH:mm:ss")

Solution 2

Even easier way to convert Date:

Convert.ToDateTime("12/02/21 10:56:09").ToString("MMM.dd,yyyy HH:mm:ss");

Solution 3

var dateTime = DateTime.ParseExact("12/02/21 10:56:09", "yy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);

var text = dateTime.ToString("MMM. dd, yyyy HH:mm:ss");

Solution 4

Assuming that you are meaning to ask how to get VB to parse the date as yy/MM/dd, the answer is simple: just use DateTime.ParseExact("12/02/12 10:56:09", "yy/MM/dd HH:mm:ss") and then use ToString() as before.

Solution 5

Try this:

DateTime.ParseExact("12/02/21 10:56:09", "yy/MM/dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).ToString("MMM. dd, yyyy HH:mm:ss");

View more solutions