Date Formatting

[winsonlee]

Dim date as string

date = '080303'

How can i do newdate = date - 21 days ?

 

[jshultz]

You would need to declare the date as a datetime, not a string.

Dim dt As DateTime
        dt = DateTime.Parse("03/03/08")
        dt = dt.AddDays(-21)
        MessageBox.Show(dt.ToShortDateString())

 

[Administrator]

You can look into the ParseExact methods to read a specific format and then use the DateTime.Add methods.

 

[petersgyoung]

DateTime.Parse("04/03/08") might be intrepreted as either 4 Mar 08 or 3 Apr 08. To solve this and some other DateTime issues, please read my blog at http://www.biswaretech.com/blog4.aspx

 

[cjard]

Dim date as string

date = '080303'

How can i do newdate = date - 21 days ?

Dim newDate as DateTime = DateTime.ParseExact("080303", "yyMMdd", CultureInfo.InvariantCulture).AddDays(-21)

 

[petersgyoung]

Asking users to input date in "080303" format is always confusing. I suggest you ask them to input date in "3 Mar 08" format. You can easily parse the date correctly. When you output the date to user, you can use yourOutputDate.ToString("dd MMM yy").

 

[JohnH]

Asking users to input date in "080303" format is always confusing.

This thread is probably not about asking user to input date in writing, but in that case you should use a DateTimePicker.