SOLVED

Last Activity Date/Time Column in LP Performance Reports

Go to solution
Highlighted
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
Highlighted

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
Highlighted

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

Highlighted
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!

Highlighted

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