[EpiData-list] Selecting Dates

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Fri Nov 7 22:28:17 CST 2008


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)

When I try
select visitdate < "01/07/2008"
I get an error message "Type Date is incompatible with type String
operation aborted"

When I try select visitdate < 01/07/2008
I get an error message "Type Date is incompatible with type Float
Operation aborted"

The only way I could find in the end was to use the month function to create a new field called visitmonth from visitdate and then select visit month <7. This worked, but I want to be able to select on the original visitdate field. Could someone help please?



Christine Roseveare
Regional Public Health
570 9194
027 495 9671

>>> <epidata-list-request at lists.umanitoba.ca> 29/11/2007 7:02 a.m. >>>
Send EpiData-list mailing list submissions to
	epidata-list at lists.umanitoba.ca 

To subscribe or unsubscribe via the World Wide Web, visit
or, via email, send a message with subject or body 'help' to
	epidata-list-request at lists.umanitoba.ca 

You can reach the person managing the list at
	epidata-list-owner at lists.umanitoba.ca 

When replying, please edit your Subject line so it is more specific
than "Re: Contents of EpiData-list digest..."

The information contained in this email and
any attachments is confidential and may be
legally privileged. If you have received this
message in error, please notify the sender
immediately and remove all copies of the message,
including any attachments.  Any views or
opinions expressed in this email (unless
otherwise stated) may not represent those of
Hutt Valley DHB. 
Thank you.
** Disclaimer added by HVDHB **

More information about the EpiData-list mailing list