Public
Occasional Advisor

Date formats in LSI

Date formats exported from LSI in a csv are not Excel (or other reporting tool) - friendly. The format exported is: yyyy-mm-dd hh whereas in metrics you get dd/mm/yyyy hh:mm which Excel immediately reads as a date/time. You can make the changes each time in Excel, but that is cumbersome for each report.

 

Is there an easier way?

2 Replies 2
Lithium Alumni (Retired)

Hello!

 

Is not possible change in LSI I think but perhaps is more easy from Excel at separe the text by columns.

 

If you open the doc with Excel, you can change automatically before make the changes separating "comas"

 

In the four step, you can choose the column A of dates, and select Date: DMY (sry for the screenshot in spanish), when you click in Finish the column appear with your desire format and don't need make the change of format.

 

I don't know if exist any way more quickly for that. 

 

datejpg.jpg

Xoxe García
Social Solutions Consultant

Thanks @xoxegarcia for the detailed explanation. 

 

Regards

Steve

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.