8 Nov
2008
8 Nov
'08
1:40 a.m.
epidata-list@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) or select visitdate < date("01/07/2008","dmy")
Kind regards, Torsten Bonde Christiansen Software Developer, EpiData.