[RESOLVED] Date format

[viper5646]

Thanks Jmcilhinney
Here how I'm using my date. I use this code to acquire the date and format it.

[CODE] Public m_Today As String = FormatDateTime(Now, DateFormat.GeneralDate)/CODE]

And then I convert it to date as follows.

  Dim todaydate As Date = CDate(RogersForm.m_Today)

[jmcilhinney]

[CODE] Public m_Today As String = FormatDateTime(Now, DateFormat.GeneralDate)/CODE]

  Dim todaydate As Date = CDate(RogersForm.m_Today)

Perhaps you could refrain from putting your actual comments inside QUOTE tags. QUOTES are for quoting other posts, not your own.

As for the issue, there is absolutely no point, under any circumstances, in converting a Date to a String and back to a Date. Like I said, Dates are binary objects that have no format so you can't possible gain anything by that and you might end up losing data or causing an error. If you want today's date then use today's date:

Dim todaysDate As Date = Date.Today

You then need to insert that value into the database as a binary date, NOT as text. You haven't actually provided us with the code that you use to insert the data into the database as I requested.