|
Sorry guys just a quick question. I have a variable, IssueDate, in date format (mm/dd/yyyy), and i want to select only cases where the variable is less than a particular date. When I just go to Select Cases, and I say IssueDate < 01/14/2004, my resulting file does not include dates only less than this date. I even did IssueDate <= 01/14/2004. Can somenoe plz tell me is this normally supposed to work and something is wrong on my end, or is there another way to select cases less than or equal to a particular date? Thanks so much!
|
|
If issuedate is really a date and not a string variable use the date.mdy
function in your logical expression--date.mdy(1,14,2004). -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of jimjohn Sent: Friday, July 11, 2008 2:29 PM To: [hidden email] Subject: Date greater than or equal to Sorry guys just a quick question. I have a variable, IssueDate, in date format (mm/dd/yyyy), and i want to select only cases where the variable is less than a particular date. When I just go to Select Cases, and I say IssueDate < 01/14/2004, my resulting file does not include dates only less than this date. I even did IssueDate <= 01/14/2004. Can somenoe plz tell me is this normally supposed to work and something is wrong on my end, or is there another way to select cases less than or equal to a particular date? Thanks so much! -- View this message in context: http://www.nabble.com/Date-greater-than-or-equal-to-tp18411969p18411969.html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== 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 |
|
Check this out for general information about working with dates in SPSS.
http://www.ats.ucla.edu/stat/spss/modules/dates.htm -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ViAnn Beadle Sent: Friday, July 11, 2008 3:45 PM To: [hidden email] Subject: Re: Date greater than or equal to If issuedate is really a date and not a string variable use the date.mdy function in your logical expression--date.mdy(1,14,2004). -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of jimjohn Sent: Friday, July 11, 2008 2:29 PM To: [hidden email] Subject: Date greater than or equal to Sorry guys just a quick question. I have a variable, IssueDate, in date format (mm/dd/yyyy), and i want to select only cases where the variable is less than a particular date. When I just go to Select Cases, and I say IssueDate < 01/14/2004, my resulting file does not include dates only less than this date. I even did IssueDate <= 01/14/2004. Can somenoe plz tell me is this normally supposed to work and something is wrong on my end, or is there another way to select cases less than or equal to a particular date? Thanks so much! -- View this message in context: http://www.nabble.com/Date-greater-than-or-equal-to-tp18411969p18411969. html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== 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 ===================== 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 |
| Free forum by Nabble | Edit this page |
