4 Replies Latest reply: Mar 31, 2017 5:03 PM by Ajinkya Bhonsle, RSS

    How to Pull the Day of the Week and time of the day from Date/time Field?

    Ajinkya Bhonsle,

      Hi Everyone,


      I am looking to build a dashboard where I can show Email's Open day of week and time of day. I have a Date/Time Field called "Activity Date".


      Activity Type: Email Opens, Website Visits, Form Submitted etc..


      I need to show the data in a timeline (time of day and day of week). For day of week I used the weekday([Activity Date]) function to pull out the week information.

      Something like this:



      Any suggestions on showing the data in time of day?