Should not use DateTime Type Descriptor for BCS Entity


Hi All,

I wana share another finding of BCS SharePoint 2010.

I had few DateTime type fields for my External Content Type, I was developing through VS 2010 to bring the sql data using a sql view. All was working well but when i saw data in external list for these fields the time was coming 5:30 mins more than the actual time (:0 Strange right ! )

like if my actual date is : 2010-12-30 17:31:53.000

DateTime in External List was coming as : 12/30/2010 11:01 PM

After googling for some time I found one article which says BCS WebPart does not understand DateTime. (BCS WebParts are used to show external list data)

So, its alternative I found was to bring the DateTime field data as string into the External List. Which worked well for me.

Ref: Check out ‘Joran Markx’ answer in this Post

Cheers!

Happy SharePointing 🙂

Advertisements

One thought on “Should not use DateTime Type Descriptor for BCS Entity

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s