3 Replies Latest reply: Oct 10, 2017 4:59 PM by Sunny Talwar RSS

    Counting datetimes

    Matt McIlvride

      I am working on a project where employees submit documents. When they do so, I receive a datetime that includes the day and time they submitted their work. I need to count the number of datetime entries in my data to establish the number of documents submitted. Furthermore, I need to count the number of unique days in which documents were submitted by employees (they must submit at least one document for it to count as a day worked).

      As an example, if I had the following dataset for an employee:

      10/10/2017 1:00 PM

      10/10/2017 12:57 PM

      10/09/2017 1:07 PM

      10/06/2017 11:34 AM

      10/04/2017 9:02 AM

      Then I need to know that there are 5 records for this employee and 4 unique days worked.