var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Earliest Time
I need to pull the row with the earliest date/time from a table which has numerous rows entered per Work Order Number e.g.
In this example it's the first row with date of 02/11/2008 and time of 10:09:45that I want to have showing in my report but at moment if I pull crdate it just picks a record at random.
First thing you're going to have to do is combine the date and time to make a datetime value.
Then you group by work order, showing only the one with the lowest (i.e. Min) datetime value.