spss date variable

[jimjohn]

can someone plz help me with this short question:

i have a variable to represent date, and its in the following format: mm/dd/yyyy
my data is from aug 2006 till today
so whenever i sort by date, i get the following:
jan 2007 first then feb 2007 then march 2007 .... then july 2007 then aug 2006, then aug 2007 ....

how do i change this variable so that when i sort it, it sorts the dates correctly from beginning to end.

thx!

[Mark Palmberg]

Is that variable actually in date format?  Doesn't sound like it.  If it
were, it'd sort correctly.

On Thu, May 8, 2008 at 10:33 AM, jimjohn <[hidden email]> wrote:

> can someone plz help me with this short question:
>
> i have a variable to represent date, and its in the following format:
> mm/dd/yyyy
> my data is from aug 2006 till today
> so whenever i sort by date, i get the following:
> jan 2007 first then feb 2007 then march 2007 .... then july 2007 then aug
> 2006, then aug 2007 ....
>
> how do i change this variable so that when i sort it, it sorts the dates
> correctly from beginning to end.
>
> thx!
> --
> View this message in context:
> http://www.nabble.com/spss-date-variable-tp17127345p17127345.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