Date to Week Conversion

[Steve Runfeldt-2]

I have a data set that includes a response date in MM/DD/YYYY format.  I am using XDATE.WEEK(Date) to calculate the week of the year.  My data starts with October 1, 2008.  When I do this the weeks start on Tuesday and end on Monday.  Is there a way I can recalculate Week and get the weeks to start on Sunday or Monday?

Thanks,

Steve


Steve Runfeldt  |  Senior Account Executive, Quantitative Research
Schwartz Consulting Partners, Inc.  |  5027 W. Laurel St.  |  Tampa, FL 33607
P: 813.207.0332  |  C: 813.431.1840  |  F: 813.207.0717
www.schwartzconsulting.com  | [hidden email]

=====================
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

[Guerrero, Rodrigo]

I am probably barking up the wrong tree, but has anyone used SPSS Text
Analysis to code and analyze transcripts?  Is there a better tool?  The
transcripts are of telephone calls from our sales center.

Thanks.

RG

Rodrigo A. Guerrero | Director Of Marketing Research and Analysis | The
Scooter Store | 830.627.4317


The information transmitted is intended only for the addressee(s) and may contain confidential or privileged material, or both.  Any review, receipt, dissemination or other use of this information by non-addressees is prohibited.   If you received this in error or are a non-addressee, please contact the sender and delete the transmitted information.

=====================
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

[Maguin, Eugene]

Steve,

>>I have a data set that includes a response date in MM/DD/YYYY format.  I
am using XDATE.WEEK(Date) to calculate the week of the year.  My data starts
with October 1, 2008.  When I do this the weeks start on Tuesday and end on
Monday.  Is there a way I can recalculate Week and get the weeks to start on
Sunday or Monday?

Yes, they do because Jan 1, 2008 must have been a Tuesday. Sounds like you
want week 1 to begin on Jan 1, 2008 falls. I think the way I'd work this is
to use the xdate.jday function, which extracts the julian day, then divide
this number by 7, truncate the result and add 1 to it. As in, (not tested
but try it and let me know)

Compute week=trunc((xdate.jday(yourdate))/7)+1.

Gene Maguin

=====================
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