12 Replies Latest reply on Nov 20, 2018 6:49 AM by Paul Wachtler

    Get the first time entry for a fixed date

    Sravya Ginne

      Hi,

       

      I am working with a project to show a graph for the employee schedules like what time of the day they are coming in. I have a date & time field like the below list.

       

      Evnt Dat

      1/3/2018 7:21:18 AM

      1/3/2018 7:21:24 AM

      1/3/2018 7:31:48 AM

      1/3/2018 2:09:12 PM

       

      I want to get the first time entry from the above list which is 7:21 and plot it against the graph for that date. Please provide me with some insight on how I can achieve this.

      Once I extract the time, I want to display it as a date on X-axis and Hour on Y-axis with a time reference line.

      Please help!