[MRBS-general] Reporting dates and times separately

[Nick H. <nr...@le...>]

Hi

Has anyone done any work to make MRBS report outputs break down the 
start and end times into their components (i.e. year, month, date, day, 
time) rather than a single text string?

Unless I'm missing something, when the report is output as a CSV it 
isn't easy to then change the sort order of rows such that entries can 
be grouped by time or date.

Doing so would require additional report columns with the start and / or 
end times broken down into their components, or with the raw UNIXTIME 
also exported.

I'm thinking this must have been done before?

Nick

-- 
Nick Holden
- - - -
Systems and Database Architect
NIHR Leicester Cardiovascular Biomedical Research Unit
Glenfield Hospital, Leicester, LE3 9QP
0116 204 4772
- - - -