Last Activity Date/Time Column in LP Performance Reports

3 replies
1426 views
Translate All

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!

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Grégoire_Miche2Accepted solution

Level 10

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

Grégoire_Miche2Accepted solution

Level 10

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

Translate

A

Anonymous

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!

Translate

Grégoire_Miche2

Level 10

HI Zach,

Be my guest.

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

-Greg

Translate

Sign up

Login with SSO

Login to the community

Login with SSO