3 Replies Latest reply: Aug 4, 2016 3:32 AM by Maiko Francisco Rugeria RSS

    Common Date

    Maiko Francisco Rugeria

      Hi!

       

      I have a data file that contains Date and Product. Example:

       

      Date                              Product

      1/2/2016 00:12 AM       ProductA

      3/12/2016 8:12 AM       ProductB

      ...

      6/27/2016 5:54 PM       ProductZ

       

      i want to get the peek hours of a product regardless of the date. I just need the time. For example, product A is sold mostly at 5:00 PM.

      I used the expression Time(date(Date)) but it returns all instances of time in each date. I just want all common instances of time to appear once. Thank you!