MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Sharepoint 2007 - Sorting is not working in BDC

  Asked By: Benjamin    Date: Jun 08    Category: MOSS    Views: 1622

I am working on BDC list. Sorting is not happening correctly in date
column in BDC list. If anybody have a idea on it. If you have just give
me some suggestion to slove it.



3 Answers Found

Answer #1    Answered By: Ned Storm     Answered On: Jun 08

Check the data type of the date column - is it really a date, or is it
being converted to a text type? If it's the latter, it will be sorted
alphabetically rather than in date order.

Answer #2    Answered By: Myron Calhoun     Answered On: Jun 08

I have checked the datatype. It is as string. How to change it to datetime?
If you have any idea to chage datatype for BDC list.

Answer #3    Answered By: Rena William     Answered On: Jun 08

I have changed the datatype string to datetime in the xml which i have
generated from BDCMetaMan. Sorting is happening. But problem is that date is
displaying like '2008-07-25T01:36:03Z'.I need to display the date in the
format of 'mm/dd/yyyy hh:mm:ss'.
Is possible to do it. If you have a idea just share with me.

Didn't find what you were looking for? Find more on Sharepoint 2007 - Sorting is not working in BDC Or get search suggestion and latest updates.