IBM Support

Date format not available, IBM SPSS Statistics 21 or 22

Troubleshooting


Problem

I have over 2 million cases and have to calculate the differences in date values. My dates came into SPSS as strings. The current format is: yyyy.mm.dd hh:mm:ss You do not have this date/time format specified in your pre-defined date formats. How can I convert this format to enable calculation of the difference between dates? I have over 5 columns with dates in this same format and need to calculate the time difference between dates in these columns.

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF014","label":"iOS"},{"code":"PF033","label":"Windows"}],"Version":"21.0;22.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.

Document Information

Modified date:
16 April 2020

UID

swg21681685