[EpiData-list] Selecting Dates

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Sat Nov 8 01:40:49 CST 2008

epidata-list at lists.umanitoba.ca wrote:
> Hello
> Could you please advise what I am doing wrong with my date selection process.
> I have a field called visitdate. Format = dd/mm/yyyy. The field itself is OK because FREQ visitdate works fine.
> My problem is when I try to select dates less than 1 July ( 01/07/2008)
The easiest way to do this is by using the dmy() or date() functions.

Then the correct syntax would be:
select visitdate < dmy(01,07,2008)
select visitdate < date("01/07/2008","dmy")

Kind regards,
Torsten Bonde Christiansen
Software Developer, EpiData.

More information about the EpiData-list mailing list