One simple way is using EpiData Analysis:
read "origfile.rec"
select dategiven<date("14/11/2007") savedata "newfile.rec" /replace
and then go back to EpiData Entry and export.
Hans
epidata-list@lists.umanitoba.ca wrote:
I am hoping someone knows the answer to the following question:
I am trying to export a selection of records from an EpiData rec file using version 3.1 to an Excel file, based on a date field. For instance, to select all records earlier than the 14th of November 2007:
dategiven < "14/11/2007"
in the filter box, but this yields an error (not a boolean expression) and the field dategiven is a <ddmmyyyy> field. I also tried without quotes and using the date function, with and without the day, month, year functions with the same result. I dare say there is a simple way to do it, but I can't see it, so if anyone can help, I'd be most grateful.
Regards,
Neville