AnsweredAssumed Answered

Extract the date from a timestamp

Question asked by user18730 on Apr 30, 2009
Latest reply on Apr 30, 2009 by mrvodka

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 

 

Outcomes