Date format is not identified by SPSS

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

Hade
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??
statman
Administrator
Posts: 2750
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!

Statman
Statistical Services

Who is online

Users browsing this forum: No registered users and 5 guests

cron