CODEWITHSUNDEEP
asp.netvb.netdate
Ishan
Ishan

Reputation: 4028

Date format in vb.net

I am using the following function to Convert a String variable to a Date. Subtract a day from it and convert the date back to a String. The code goes as follows

Dim edate As String
Dim expenddt As Date

edate = txtenddt.Text
expenddt = Date.ParseExact(edate, "dd/MM/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo)
expenddt = expenddt.AddDays(-1)

Dim asd As String = expenddt.ToString

If edate has a value 29/12/2011 than the value in expenddt gets changed to a different format and the value in expenddt comes to 12/29/2011 and later after subtracting a day expenddt is 12/28/2011 and than when i convert it back to a String i get the value in asd as "12/28/2012 12:00:00 AM"

I have changed the date format on my system to d/M/yyyy in Regional And Language Option in Control Panel but i still get a different format in expenddt

Can anyone explain me why this is happening? How can i keep the format of the date in dd/mm/yyyy e.g 29/12/2011 and after Subtracting a day it should remain 28/12/2011 and not 12/29/2011

Upvotes: 0

Views: 8357

Answers (2)

KV Prajapati
KV Prajapati

Reputation: 94653

Use Date.ToString() to convert date to string with dd/MM/yyyy format.

Dim asd As String = expenddt.ToString("dd/MM/yyyy")

Upvotes: 2

Rajeshkumar Kandhasamy
Rajeshkumar Kandhasamy

Reputation: 6461

Just try this:

Dim dateString As String = "Mon 16 Jun 8:30 AM 2008"
Dim format As String = "ddd dd MMM h:mm tt yyyy"
Dim dateTime__1 As DateTime = DateTime.ParseExact(dateString, format, CultureInfo.InvariantCulture)

hope this may helpful....

Upvotes: 0

Related Questions