Date format is not identified by SPSS

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Wed Jun 28, 2017 12:52 pm

Date format is not identified by SPSS

Postby Hade » Wed Jun 28, 2017 12:58 pm

Hi all,

If you could please help me in this request.
I'm working on a massive dataset. I want to change a string variable to date variable. However, the string variable I have is in a format that cannot be identified by date and time wizard; the format is ddmmmyyy for example 28jun2017. I tried to use other date format but that results in missing data. What should I do??
Posts: 2760
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: Date format is not identified by SPSS

Postby statman » Wed Jun 28, 2017 1:05 pm

How did you get the data, e.g., imported from Excel

Also ............
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statistical Services

Who is online

Users browsing this forum: No registered users and 2 guests