cancel
Showing results for 
Search instead for 
Did you mean: 

Date Formatting in List View

Former Member
0 Kudos
147

I have a table which displays 3 rows of data using a list view.

I have the list view function perfectly and performing its expected task. However, the data formatting of one of the columns is incorrect.

Excel displays the dates in the "DD.MM.YYYY" format, which is what I require. But when I preview or export the SWF file it displays the date as "YYYY-MM-DD HH:MM:SS". This is not helpful!

Any suggestions on how I could change the format of this column?

James

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi James,

In list view we dnt have an option to format the columns .

Try using Score card which has the same functionality of list view and it allows us to format the columns.

@Sri

Answers (2)

Answers (2)

Former Member
0 Kudos

I'm having the same issue with the scorecard.

Regardless of whether I select Date, From Excel or text for the format, it always defaults to the incorrect layout once conveted.

Any further suggestions welcome,

James

Former Member
0 Kudos

k...

format that column in excel and delete the component (score card in xcelsius) and take a new one and mapp it again ..just try..

@Sri

Edited by: Sri kamesh on Jun 20, 2011 12:23 PM

Former Member
0 Kudos

In the appearance properties of the list box, and then text, make sure you have the option as FROM SPREAD SHEET. if that is there already then select a custom format from the drop down.

if above doesn't work then pull ur date data as character which excel will not messup.

Thanks,

Karthik