[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