SOLVED

Re: Last Activity Date/Time Column in LP Performance Reports

Go to solution
Anonymous
Not applicable

Last Activity Date/Time Column in LP Performance Reports

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

Re: Last Activity Date/Time Column in LP Performance Reports

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

View solution in original post

3 REPLIES 3
Grégoire_Miche2
Level 10

Re: Last Activity Date/Time Column in LP Performance Reports

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

Anonymous
Not applicable

Re: Last Activity Date/Time Column in LP Performance Reports

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
Level 10

Re: Last Activity Date/Time Column in LP Performance Reports

HI Zach,

Be my guest.

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

-Greg