1 Reply Latest reply on Aug 13, 2015 3:02 PM by Patrick Van Der Hyde

    how to identify distinct count between day before yesterday 7 pm to yesterday 7 pm

    Rahul Sahil



      I want a distinct count of employees logged in between  day before yesterday 10 pm to yesterday 10 pm and I have two columns for date logged date (2015-06-21,2015-06-22,etc ) and logged time (20:00:00,18:05:00,17:06:07 etc) from which data is been populated.





      Report Ex:


                                                2015-06-21(7pm) to 2015-06-22  (7 pm)


      Countd[employees]                                    20


      Want to know how to combine two fields data and get a count between the specific time of Day before yesterday to Yesterday