Wrong date format in DB

lustigon · November 4th, 2010, 09:08 PM

Hello all...

In the section "Configuring Columns or Fields of Data-bound Controls" on page 453, I get a wrong date format by the end of the TryItOut.

even after adding

Code:

HtmlEncodeFormatString="True"

to the BoundField for the CreateDateTime.
According to the book(figure 13-14-page 457), the date format should be 10/27/2010 8:11 PM.
What I get is 27-Oct-10 8:11 PM.

I double checked, and I'm quite sure I went by the book exactly.

Any suggestions? Or may be that's normal? but still it's not the same as in the boook..

Thanks...
Lustigon...

lustigon · November 4th, 2010, 10:05 PM

Well, found a fix.

On Windows 7
---------------
control panel - Region and Language - a dialog opens - at the format tab in the Short date drop-down list, one should choose M/dd/yyyy.

That fixed it...

Imar · November 5th, 2010, 02:51 AM

Hi Lustigon,

Yes, your Windows settings are used in ASP.NET / VWD for regional settings such as dates, time and currency. There's no real need to change that format to follow along with the book. You just need to be aware of the differences. So, if your machine has a DD-MM-YYYY format and you enter a date in a text box, you should enter it in that format.

Other than that, things should work fine regardless the settings in Windows.

Cheers,

Imar