Dates
Locked
 
|
Good morning, Using SPSS Version 22, have date fields = 10/22/2012, when I select with date field = 10/22/2012 it is not selecting. What is behind that date that I am not seeing so that
I can select dates, tried different formats?? Thank You Barbara Lombardo
Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961
Fax: 856-374-5016 P
Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and
privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. ![[env+email+sig.bmp]](http://4.bp.blogspot.com/_YlaBSTlxPfk/RfaSq6P4INI/AAAAAAAAARs/iF88cSh9j40/s1600/env%2Bemail%2Bsig.bmp)
|
|
|
An integer representing seconds since a
date in the 16th century.
Try: select if datevar=date.mdy(10,22,2012). Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: "Lombardo, Barbara" <[hidden email]> To: [hidden email], Date: 12/11/2013 08:09 AM Subject: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> Good morning, Using SPSS Version 22, have date fields = 10/22/2012, when I select with date field = 10/22/2012 it is not selecting. What is behind that date that I am not seeing so that I can select dates, tried different formats?? Thank You Barbara Lombardo Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 P Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system.
|
Administrator
|
In fact # of seconds since Oct 15,1582 (the beginning of the Gregorian calendar).
Kinda sucks for anthropologists ;-)))
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
|
Technically, the day before October 15,
1582, which may or may not be October 4. The lowest valid value is 86400,
which resolves to October 15, 1582.
Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: David Marso <[hidden email]> To: [hidden email], Date: 12/11/2013 09:10 AM Subject: Re: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> In fact # of seconds since Oct 15,1582 (the beginning of the Gregorian calendar). Kinda sucks for anthropologists ;-))) Rick Oliver wrote > An integer representing seconds since a date in the 16th century. > > Try: > > select if datevar=date.mdy(10,22,2012). > > Rick Oliver > Senior Information Developer > IBM Business Analytics (SPSS) > E-mail: > oliverr@.ibm > > > > From: "Lombardo, Barbara" < > BLombardo@ > > > To: > SPSSX-L@.uga > , > Date: 12/11/2013 08:09 AM > Subject: Dates > Sent by: "SPSSX(r) Discussion" < > SPSSX-L@.uga > > > > > > Good morning, > > Using SPSS Version 22, have date fields = 10/22/2012, when I select with > date field = 10/22/2012 it is not selecting. What is behind that date > that I am not seeing so that I can select dates, tried different formats?? > > Thank You > > > Barbara Lombardo > Institutional Research > Camden County College > Blackwood NJ 08012 > Office: 856-374-4961 > Fax: 856-374-5016 > > P Think before you print. > CONFIDENTIALITY: This e-mail (including any attachments) may contain > confidential, proprietary and privileged information, and unauthorized > disclosure or use is prohibited. If you received this e-mail in error, > please notify the sender and delete this e-mail from your system. > > > ----- Please reply to the list and not to my personal email. Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723589.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 |
|
Administrator
|
If you want to get 'technical', 46400 resolves to Midnight Oct 15,1582 so I'm not sure where "the day before" comes into your reckoning!
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
|
I think 46400 resolves to sysmis.
data list free /x. begin data 46400 86399 86400 end data. formats x (adate10). list. Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: David Marso <[hidden email]> To: [hidden email], Date: 12/11/2013 11:39 AM Subject: Re: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> If you want to get 'technical', 46400 resolves to Midnight Oct 15,1582 so I'm not sure where "the day before" comes into your reckoning! Rick Oliver wrote > Technically, the day before October 15, 1582, which may or may not be > October 4. The lowest valid value is 86400, which resolves to October 15, > 1582. > > Rick Oliver > Senior Information Developer > IBM Business Analytics (SPSS) > E-mail: > oliverr@.ibm > > > > From: David Marso < > david.marso@ > > > To: > SPSSX-L@.uga > , > Date: 12/11/2013 09:10 AM > Subject: Re: Dates > Sent by: "SPSSX(r) Discussion" < > SPSSX-L@.uga > > > > > > In fact # of seconds since Oct 15,1582 (the beginning of the Gregorian > calendar). > Kinda sucks for anthropologists ;-))) > > > Rick Oliver wrote >> An integer representing seconds since a date in the 16th century. >> >> Try: >> >> select if datevar=date.mdy(10,22,2012). >> >> Rick Oliver >> Senior Information Developer >> IBM Business Analytics (SPSS) >> E-mail: > >> oliverr@.ibm > >> >> >> >> From: "Lombardo, Barbara" < > >> BLombardo@ > >> > >> To: > >> SPSSX-L@.uga > >> , >> Date: 12/11/2013 08:09 AM >> Subject: Dates >> Sent by: "SPSSX(r) Discussion" < > >> SPSSX-L@.uga > >> > >> >> >> >> Good morning, >> >> Using SPSS Version 22, have date fields = 10/22/2012, when I select with >> date field = 10/22/2012 it is not selecting. What is behind that date >> that I am not seeing so that I can select dates, tried different > formats?? >> >> Thank You >> >> >> Barbara Lombardo >> Institutional Research >> Camden County College >> Blackwood NJ 08012 >> Office: 856-374-4961 >> Fax: 856-374-5016 >> >> P Think before you print. >> CONFIDENTIALITY: This e-mail (including any attachments) may contain >> confidential, proprietary and privileged information, and unauthorized >> disclosure or use is prohibited. If you received this e-mail in error, >> please notify the sender and delete this e-mail from your system. >> >> >> > > > > > > ----- > Please reply to the list and not to my personal email. > Those desiring my consulting or training services please feel free to > email me. > --- > "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos > ne forte conculcent eas pedibus suis." > Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in > abyssum?" > -- > View this message in context: > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723589.html > Sent from the SPSSX Discussion mailing list archive at Nabble.com. > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- Please reply to the list and not to my personal email. Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723597.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 |
|
Administrator
|
My bad! I obviously meant 86400 which is 00:00:00 on 0ct,15,1582.
Where do you get the 'day before' in your previous post?
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
|
86400 seconds = 1 day.
If 86400 is 15-OCT-1582 00:00:00, then 0 is midnight of the day before that. Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: David Marso <[hidden email]> To: [hidden email], Date: 12/11/2013 11:56 AM Subject: Re: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> My bad! I *obviously* meant 86400 which is 00:00:00 on 0ct,15,1582. Where do you get the 'day before' in your previous post? Rick Oliver wrote > I think 46400 resolves to sysmis. > > data list free /x. > begin data > 46400 86399 86400 > end data. > formats x (adate10). > list. > > Rick Oliver > Senior Information Developer > IBM Business Analytics (SPSS) > E-mail: > oliverr@.ibm > > > > From: David Marso < > david.marso@ > > > To: > SPSSX-L@.uga > , > Date: 12/11/2013 11:39 AM > Subject: Re: Dates > Sent by: "SPSSX(r) Discussion" < > SPSSX-L@.uga > > > > > > If you want to get 'technical', 46400 resolves to Midnight Oct 15,1582 so > I'm > not sure where "the day before" comes into your reckoning! > > Rick Oliver wrote >> Technically, the day before October 15, 1582, which may or may not be >> October 4. The lowest valid value is 86400, which resolves to October > 15, >> 1582. >> >> Rick Oliver >> Senior Information Developer >> IBM Business Analytics (SPSS) >> E-mail: > >> oliverr@.ibm > >> >> >> >> From: David Marso < > >> david.marso@ > >> > >> To: > >> SPSSX-L@.uga > >> , >> Date: 12/11/2013 09:10 AM >> Subject: Re: Dates >> Sent by: "SPSSX(r) Discussion" < > >> SPSSX-L@.uga > >> > >> >> >> >> In fact # of seconds since Oct 15,1582 (the beginning of the Gregorian >> calendar). >> Kinda sucks for anthropologists ;-))) >> >> >> Rick Oliver wrote >>> An integer representing seconds since a date in the 16th century. >>> >>> Try: >>> >>> select if datevar=date.mdy(10,22,2012). >>> >>> Rick Oliver >>> Senior Information Developer >>> IBM Business Analytics (SPSS) >>> E-mail: >> >>> oliverr@.ibm >> >>> >>> >>> >>> From: "Lombardo, Barbara" < >> >>> BLombardo@ >> >>> > >>> To: >> >>> SPSSX-L@.uga >> >>> , >>> Date: 12/11/2013 08:09 AM >>> Subject: Dates >>> Sent by: "SPSSX(r) Discussion" < >> >>> SPSSX-L@.uga >> >>> > >>> >>> >>> >>> Good morning, >>> >>> Using SPSS Version 22, have date fields = 10/22/2012, when I select > with >>> date field = 10/22/2012 it is not selecting. What is behind that > date >>> that I am not seeing so that I can select dates, tried different >> formats?? >>> >>> Thank You >>> >>> >>> Barbara Lombardo >>> Institutional Research >>> Camden County College >>> Blackwood NJ 08012 >>> Office: 856-374-4961 >>> Fax: 856-374-5016 >>> >>> P Think before you print. >>> CONFIDENTIALITY: This e-mail (including any attachments) may contain >>> confidential, proprietary and privileged information, and unauthorized >>> disclosure or use is prohibited. If you received this e-mail in error, >>> please notify the sender and delete this e-mail from your system. >>> >>> >>> >> >> >> >> >> >> ----- >> Please reply to the list and not to my personal email. >> Those desiring my consulting or training services please feel free to >> email me. >> --- >> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante > porcos >> ne forte conculcent eas pedibus suis." >> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff > in >> abyssum?" >> -- >> View this message in context: >> > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723589.html >> Sent from the SPSSX Discussion mailing list archive at Nabble.com. >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to > >> LISTSERV@.UGA > >> (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 > > > > > > ----- > Please reply to the list and not to my personal email. > Those desiring my consulting or training services please feel free to > email me. > --- > "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos > ne forte conculcent eas pedibus suis." > Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in > abyssum?" > -- > View this message in context: > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723597.html > Sent from the SPSSX Discussion mailing list archive at Nabble.com. > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- Please reply to the list and not to my personal email. Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723599.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 |
|
|
How about helping the OP with her selection problem then arguing over the bounds of the date representation. But first, the OP needs to explain how she is attempting to select on a date. From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rick Oliver 86400 seconds = 1 day.
|
|
|
I already did that and she responded that
it worked:
select if datevar=date.mdy(month, day, year). Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: ViAnn Beadle <[hidden email]> To: [hidden email], Date: 12/11/2013 12:23 PM Subject: Re: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> How about helping the OP with her selection problem then arguing over the bounds of the date representation. But first, the OP needs to explain how she is attempting to select on a date. From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Rick Oliver Sent: Wednesday, December 11, 2013 11:14 AM To: [hidden email] Subject: Re: Dates 86400 seconds = 1 day. If 86400 is 15-OCT-1582 00:00:00, then 0 is midnight of the day before that. Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: oliverr@... From: David Marso <david.marso@...> To: [hidden email], Date: 12/11/2013 11:56 AM Subject: Re: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> My bad! I *obviously* meant 86400 which is 00:00:00 on 0ct,15,1582. Where do you get the 'day before' in your previous post? Rick Oliver wrote > I think 46400 resolves to sysmis. > > data list free /x. > begin data > 46400 86399 86400 > end data. > formats x (adate10). > list. > > Rick Oliver > Senior Information Developer > IBM Business Analytics (SPSS) > E-mail: > oliverr@.ibm > > > > From: David Marso < > david.marso@ > > > To: > [hidden email] > , > Date: 12/11/2013 11:39 AM > Subject: Re: Dates > Sent by: "SPSSX(r) Discussion" < > [hidden email] > > > > > > If you want to get 'technical', 46400 resolves to Midnight Oct 15,1582 so > I'm > not sure where "the day before" comes into your reckoning! > > Rick Oliver wrote >> Technically, the day before October 15, 1582, which may or may not be >> October 4. The lowest valid value is 86400, which resolves to October > 15, >> 1582. >> >> Rick Oliver >> Senior Information Developer >> IBM Business Analytics (SPSS) >> E-mail: > >> oliverr@.ibm > >> >> >> >> From: David Marso < > >> david.marso@ > >> > >> To: > >> [hidden email] > >> , >> Date: 12/11/2013 09:10 AM >> Subject: Re: Dates >> Sent by: "SPSSX(r) Discussion" < > >> [hidden email] > >> > >> >> >> >> In fact # of seconds since Oct 15,1582 (the beginning of the Gregorian >> calendar). >> Kinda sucks for anthropologists ;-))) >> >> >> Rick Oliver wrote >>> An integer representing seconds since a date in the 16th century. >>> >>> Try: >>> >>> select if datevar=date.mdy(10,22,2012). >>> >>> Rick Oliver >>> Senior Information Developer >>> IBM Business Analytics (SPSS) >>> E-mail: >> >>> oliverr@.ibm >> >>> >>> >>> >>> From: "Lombardo, Barbara" < >> >>> BLombardo@ >> >>> > >>> To: >> >>> [hidden email] >> >>> , >>> Date: 12/11/2013 08:09 AM >>> Subject: Dates >>> Sent by: "SPSSX(r) Discussion" < >> >>> [hidden email] >> >>> > >>> >>> >>> >>> Good morning, >>> >>> Using SPSS Version 22, have date fields = 10/22/2012, when I select > with >>> date field = 10/22/2012 it is not selecting. What is behind that > date >>> that I am not seeing so that I can select dates, tried different >> formats?? >>> >>> Thank You >>> >>> >>> Barbara Lombardo >>> Institutional Research >>> Camden County College >>> Blackwood NJ 08012 >>> Office: 856-374-4961 >>> Fax: 856-374-5016 >>> >>> P Think before you print. >>> CONFIDENTIALITY: This e-mail (including any attachments) may contain >>> confidential, proprietary and privileged information, and unauthorized >>> disclosure or use is prohibited. If you received this e-mail in error, >>> please notify the sender and delete this e-mail from your system. >>> >>> >>> >> >> >> >> >> >> ----- >> Please reply to the list and not to my personal email. >> Those desiring my consulting or training services please feel free to >> email me. >> --- >> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante > porcos >> ne forte conculcent eas pedibus suis." >> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff > in >> abyssum?" >> -- >> View this message in context: >> > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723589.html >> Sent from the SPSSX Discussion mailing list archive at Nabble.com. >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to > >> LISTSERV@.UGA > >> (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 > > > > > > ----- > Please reply to the list and not to my personal email. > Those desiring my consulting or training services please feel free to > email me. > --- > "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos > ne forte conculcent eas pedibus suis." > Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in > abyssum?" > -- > View this message in context: > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723597.html > Sent from the SPSSX Discussion mailing list archive at Nabble.com. > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- Please reply to the list and not to my personal email. Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723599.html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@... (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 |
|
Administrator
|
Indeed, the first reply in the thread.
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
Administrator
|
In reply to this post by Rick Oliver-3
I stand corrected ;-)
Your 'may or may not have been Oct 4' is an interesting response. Probably depends on where one was at the time. http://www.timeanddate.com/calendar/gregorian-calendar.html Sounds like a real flustercluck. From the FM: Date and time formats are both input and output formats. Like numeric formats, each input format generates a default output format, automatically expanded (if necessary) to accommodate display width. Internally, all date and time format values are stored as a number of seconds: date formats (e.g., DATE, ADATE, SDATE, DATETIME) are stored as the number of seconds since October 14, 1582 Which leads to the question was there an Oct 14, 1582 ? Is the manual wrong? OTOH: CEFGW ;-)
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
|
|
October 14, 1582 is a literary conceit.
The Gregorian calendar skips 10 days between October 4 and October 15.
I don't know why midnight on October 15 is 86400 and not 0.
Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: David Marso <[hidden email]> To: [hidden email], Date: 12/11/2013 12:43 PM Subject: Re: Dates Sent by: "SPSSX(r) Discussion" <[hidden email]> I stand corrected ;-) Your 'may or may not have been Oct 4' is an interesting response. Probably depends on where one was at the time. http://www.timeanddate.com/calendar/gregorian-calendar.html Sounds like a real flustercluck. From the FM: Date and time formats are both input and output formats. Like numeric formats, each input format generates a default output format, automatically expanded (if necessary) to accommodate display width. Internally, all date and time format values are stored as a number of seconds: date formats (e.g., DATE, ADATE, SDATE, DATETIME) are stored as the number of seconds since *October 14, 1582 * Which leads to the question was there an Oct 14, 1582 ? Is the manual wrong? OTOH: CEFGW ;-) Rick Oliver wrote > 86400 seconds = 1 day. > > If 86400 is 15-OCT-1582 00:00:00, then 0 is midnight of the day before > that. > > Rick Oliver > Senior Information Developer > IBM Business Analytics (SPSS) > E-mail: > oliverr@.ibm > > > > From: David Marso < > david.marso@ > > > To: > SPSSX-L@.uga > , > Date: 12/11/2013 11:56 AM > Subject: Re: Dates > Sent by: "SPSSX(r) Discussion" < > SPSSX-L@.uga > > > > > > My bad! I *obviously* meant 86400 which is 00:00:00 on 0ct,15,1582. > Where do you get the 'day before' in your previous post? > > > Rick Oliver wrote >> I think 46400 resolves to sysmis. >> >> data list free /x. >> begin data >> 46400 86399 86400 >> end data. >> formats x (adate10). >> list. >> >> Rick Oliver >> Senior Information Developer >> IBM Business Analytics (SPSS) >> E-mail: > >> oliverr@.ibm > >> >> >> >> From: David Marso < > >> david.marso@ > >> > >> To: > >> SPSSX-L@.uga > >> , >> Date: 12/11/2013 11:39 AM >> Subject: Re: Dates >> Sent by: "SPSSX(r) Discussion" < > >> SPSSX-L@.uga > >> > >> >> >> >> If you want to get 'technical', 46400 resolves to Midnight Oct 15,1582 > so >> I'm >> not sure where "the day before" comes into your reckoning! >> >> Rick Oliver wrote >>> Technically, the day before October 15, 1582, which may or may not be >>> October 4. The lowest valid value is 86400, which resolves to October >> 15, >>> 1582. >>> >>> Rick Oliver >>> Senior Information Developer >>> IBM Business Analytics (SPSS) >>> E-mail: >> >>> oliverr@.ibm >> >>> >>> >>> >>> From: David Marso < >> >>> david.marso@ >> >>> > >>> To: >> >>> SPSSX-L@.uga >> >>> , >>> Date: 12/11/2013 09:10 AM >>> Subject: Re: Dates >>> Sent by: "SPSSX(r) Discussion" < >> >>> SPSSX-L@.uga >> >>> > >>> >>> >>> >>> In fact # of seconds since Oct 15,1582 (the beginning of the Gregorian >>> calendar). >>> Kinda sucks for anthropologists ;-))) >>> >>> >>> Rick Oliver wrote >>>> An integer representing seconds since a date in the 16th century. >>>> >>>> Try: >>>> >>>> select if datevar=date.mdy(10,22,2012). >>>> >>>> Rick Oliver >>>> Senior Information Developer >>>> IBM Business Analytics (SPSS) >>>> E-mail: >>> >>>> oliverr@.ibm >>> >>>> >>>> >>>> >>>> From: "Lombardo, Barbara" < >>> >>>> BLombardo@ >>> >>>> > >>>> To: >>> >>>> SPSSX-L@.uga >>> >>>> , >>>> Date: 12/11/2013 08:09 AM >>>> Subject: Dates >>>> Sent by: "SPSSX(r) Discussion" < >>> >>>> SPSSX-L@.uga >>> >>>> > >>>> >>>> >>>> >>>> Good morning, >>>> >>>> Using SPSS Version 22, have date fields = 10/22/2012, when I select >> with >>>> date field = 10/22/2012 it is not selecting. What is behind that >> date >>>> that I am not seeing so that I can select dates, tried different >>> formats?? >>>> >>>> Thank You >>>> >>>> >>>> Barbara Lombardo >>>> Institutional Research >>>> Camden County College >>>> Blackwood NJ 08012 >>>> Office: 856-374-4961 >>>> Fax: 856-374-5016 >>>> >>>> P Think before you print. >>>> CONFIDENTIALITY: This e-mail (including any attachments) may contain >>>> confidential, proprietary and privileged information, and unauthorized >>>> disclosure or use is prohibited. If you received this e-mail in error, >>>> please notify the sender and delete this e-mail from your system. >>>> >>>> >>>> >>> >>> >>> >>> >>> >>> ----- >>> Please reply to the list and not to my personal email. >>> Those desiring my consulting or training services please feel free to >>> email me. >>> --- >>> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante >> porcos >>> ne forte conculcent eas pedibus suis." >>> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff >> in >>> abyssum?" >>> -- >>> View this message in context: >>> >> > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723589.html >>> Sent from the SPSSX Discussion mailing list archive at Nabble.com. >>> >>> ===================== >>> To manage your subscription to SPSSX-L, send a message to >> >>> LISTSERV@.UGA >> >>> (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 >> >> >> >> >> >> ----- >> Please reply to the list and not to my personal email. >> Those desiring my consulting or training services please feel free to >> email me. >> --- >> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante > porcos >> ne forte conculcent eas pedibus suis." >> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff > in >> abyssum?" >> -- >> View this message in context: >> > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723597.html >> Sent from the SPSSX Discussion mailing list archive at Nabble.com. >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to > >> LISTSERV@.UGA > >> (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 > > > > > > ----- > Please reply to the list and not to my personal email. > Those desiring my consulting or training services please feel free to > email me. > --- > "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos > ne forte conculcent eas pedibus suis." > Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in > abyssum?" > -- > View this message in context: > http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723599.html > Sent from the SPSSX Discussion mailing list archive at Nabble.com. > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- Please reply to the list and not to my personal email. Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Dates-tp5723585p5723608.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 |
|
|
Only a few countries adopted the Gregorian calendar in 1582, so while the date theoretically represented by zero would have been as Rick said, October 15th could be represented by several different values. !!
|
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |