1 Reply Latest reply on Apr 30, 2009 5:22 PM by mrvodka

    Extract the date from a timestamp

    user18730

      Title

      Extract the date from a timestamp

      Post

      I receive a CSV file that contains a temperture reading taken every minute, 24 hours a day for the entire month, looks like this

       

       

      4/28/2009 2:32:00 PM 56.6

       

      I need to generate a report that shows the min temp, max temp, and average for the day. In other words, I want to show the temps for one day with the min, max, and average, displayed at the bottom of each day. Then show the same info for the next day, etc.

      Any ideas