Dates and SPSS

[Genevieve Thompson]

Hi,

I am using the database wizard to extract some data. Do any of you know
how to sort it so that it only extracts particular dates for me using
the wizard?

 

Thanks.

 

Genevieve Thompson

Policy and Program Analyst

 

OANHSS

Suite 700 - 7050 Weston Rd.

Woodbridge, ON  L4L 8G7

Tel:  [phone] x 241 Fax:  [phone]

[hidden email] <mailto:[hidden email]>

www.oanhss.org <http://www.oanhss.org/>

 

OANHSS Upcoming Events

 

Diversity in Action - 3 Regional Sessions


Bullying in the Workplace - 3 Regional Sessions


HR Management Series - Meeting the Challenges of Managing Your Workforce
Four one-day sessions focused on the core competencies of human resource
management

 

 

For dates and registration information go to www.oanhss.org
<http://www.oanhss.org>  

 

------------------------------------------------------------------------
------------------------------------------------------------------------

This electronic communication is from the Ontario Association of
Non-Profit Homes and Services for Seniors. It is for the intended
recipient only and may contain confidential and/or privileged
information. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon this information, by persons or
entities other than the intended recipient, is prohibited. If you
received this in error, please contact the sender and delete the
material from your computer.

 

 

====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Oliver, Richard]

From the Database Wizard help:

If the SQL contains WHERE clauses with expressions for case selection, dates and times in expressions need to be specified in a special manner (including the curly braces shown in the examples):

* Date literals should be specified using the general form {d 'yyyy-mm-dd'}.

* Time literals should be specified using the general form {t 'hh:mm:ss'}.

* Date/time literals (timestamps) should be specified using the general form {ts 'yyyy-mm-dd hh:mm:ss'}.

* The entire date and/or time value must be enclosed in single quotes. Years must be expressed in four-digit form, and dates and times must contain two digits for each portion of the value. For example January 1, 2005, 1:05 AM would be expressed as:

{ts '2005-01-01 01:05:00'}


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Genevieve Thompson
Sent: Friday, August 22, 2008 2:40 PM
To: [hidden email]
Subject: Dates and SPSS

Hi,

I am using the database wizard to extract some data. Do any of you know
how to sort it so that it only extracts particular dates for me using
the wizard?



Thanks.



Genevieve Thompson

Policy and Program Analyst



OANHSS

Suite 700 - 7050 Weston Rd.

Woodbridge, ON  L4L 8G7

Tel:  [phone] x 241 Fax:  [phone]

[hidden email] <mailto:[hidden email]>

www.oanhss.org <http://www.oanhss.org/>



OANHSS Upcoming Events



Diversity in Action - 3 Regional Sessions


Bullying in the Workplace - 3 Regional Sessions


HR Management Series - Meeting the Challenges of Managing Your Workforce
Four one-day sessions focused on the core competencies of human resource
management





For dates and registration information go to www.oanhss.org
<http://www.oanhss.org>



------------------------------------------------------------------------
------------------------------------------------------------------------

This electronic communication is from the Ontario Association of
Non-Profit Homes and Services for Seniors. It is for the intended
recipient only and may contain confidential and/or privileged
information. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon this information, by persons or
entities other than the intended recipient, is prohibited. If you
received this in error, please contact the sender and delete the
material from your computer.





=======
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD