Last Activity Date/Time Column in LP Performance Reports | Community
Skip to main content
March 18, 2016
Solved

Last Activity Date/Time Column in LP Performance Reports

  • March 18, 2016
  • 1 reply
  • 1406 views

Anyone know how to easily export and sort that information chronologically? It's not recognized in excel as date so you can't sort. Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

Hi Zach,

In excel, if you set the format of the column to "long date", it should recognize the data as dates. YOu will have to browse through each line and type "enter", just to force the format change.

-Greg

1 reply

Grégoire_Miche2
Grégoire_Miche2Accepted solution
New Participant
March 20, 2016

Hi Zach,

In excel, if you set the format of the column to "long date", it should recognize the data as dates. YOu will have to browse through each line and type "enter", just to force the format change.

-Greg

March 21, 2016

Ah okay, I tried forcing long date but didn't press enter in each cell so I'll give that a shot. As always, thanks Greg!

Grégoire_Miche2
New Participant
March 21, 2016

HI Zach,

Be my guest.

Mark it answered, so that it gets out of the radar.

-Greg