[EpiData-list] How to: select with dates and an open question ? ?

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Sun Oct 30 08:24:54 CST 2005


This should work:
* ----------------------------------------
DEFINE DATEMIN <dd/mm/yyyy>
DEFINE DATEMAX <dd/mm/yyyy>

LET DATEMIN = dmy(? First date: e.g. (02/12/1989)  ?,"dmy")
LET DATEMAX = ? Second date : e.g. (02/12/1999) ?,"dmy")

SELECT (DATEADM <= DATEMIN) AND (DATEDIS >= DATEMAX)
FREQ AGE
................................................................

or to select directly in comparison with a specific date using the dmy 
function:

select date(? Write date, dd/mm/yyyy ?,"dmy") > dmy(10,02,1999)

Jens Lauritsen
EpiData Association


More information about the EpiData-list mailing list