Troubleshooting
Problem
I have a date variable in my data set in the format of dd-mmm-yyyy, and I want to select cases for a given date. I tried using the syntax: SELECT IF (date_var = DATE.DMY(30,6,97)). EXECUTE. but none of my cases are selected. I can see in my data that there are cases with this date, and I can't seem to figure out why they are not being selected. Furthermore, if I change the "=" sign in the argument to ">", "<", or anything other than "=", the correct cases are selected. Why are they not being selected when I use the "=" ?
[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"18.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
17488
Was this topic helpful?
Document Information
Modified date:
16 April 2020
UID
swg21476170