JQuery: extract date from datetime

Hi @cuongnd, If you're interested in only showing the person and their last_seen property, you can use the map (https://mixpanel.com/help/reference/jql/api-reference#api/transformations/map) function.

This would look like the following:

function main() {

  

  return People() // take all People profiles in your project 

  

  .filter(function(user){ // filter takes in a function

    return user.time && user.properties.$last_seen; // show only those that have a last seen property 

  })

  .map(function(user) { // take those with only a last seen property 

            return{

              distinct_id : user.properties.$distinct_id,  // display the distinct_id 

              City : user.properties.$city,  // display the city 

              email : user.properties.$email,  // display the email

              Last_seen : new Date(user.time).toISOString().slice(0,-14) // display last seen

              

            };

            });

}

Hope this helps!