timestamp format, rounding, and aggregation
I have been given a data table that contains a couple of columns that require some formatting changes. Specifically I need to:1. alter the "Date/Time" column format from 16/08/2013 2:32.01 PM, to 2013-08-13 14:32:01 (this does not appear to be one of JMPs predefined formats)2. round the timestamp to the nearest 15 min interval. In this case 2013-08-13 14:32:01 would become 2013-08-13 14:30:00Final...