Re: Cart date/time
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66531
interpreted = N
texte = **Correction: GET DATE & TIME FROM CART #[your_cart]:
-Dan On Tue, 28 Mar 2006 09:03:18 -0800 "Dan Strong"
wrote: > Mark, > > I spent more than a few non-billable hours figuring this out a few years ago when business >wasn't so good :) > -Dan > > ================= > [text multi=T]offset=-9&your_cart=[cart][!]or whatever cart# you're trying to reverse[/!][/text] > > [text show=f]offset_in_seconds=[math][offset]*3600[/math][/text] > [text show=f]offset_as_time=[math time]offset_in_seconds[/math][/text] > [text show=f]scrubbed_cart=[getchars start=1&end=10][your_cart][/getchars][/text] > [text >show=f]days_since_epoch=[math]floor(([scrubbed_cart]+[offset_in_seconds])/86400)[/math][/text] > [text show=f]seconds_since_midnight=[Format >Seconds_To_Time][math][scrubbed_cart]%86400[/math][/format][/text] > > GET DATE & TIME FROM CART #[cart]:
> [math date]{1/1/1970}+{00/[days_since_epoch]/0000}[/math] - > [math time]{[seconds_since_midnight]}-{07:00:00}[/Math] > ================= > > > On Tue, 28 Mar 2006 13:22:22 +0100 > Mark Derrick wrote: >> Several years ago, I vaguely remember someone posting a message with a code sample showing how >>to pull the cart number apart, and produce the date/time it was created - but I can't find the >>posting in the archives - probably due to my poor searching abilities - or SM removing it :-) >> >> I'm looking to analyze incoming cart refs, and check whether they're more than 24 hours old, >>and this seems to be the only way to do this. >> >> Any pointers/tips appreciated. >> >> >> Mark. >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
**Correction: GET DATE & TIME FROM CART #[your_cart]:
-Dan On Tue, 28 Mar 2006 09:03:18 -0800 "Dan Strong" wrote: > Mark, > > I spent more than a few non-billable hours figuring this out a few years ago when business >wasn't so good :) > -Dan > > ================= > [text multi=T]offset=-9&your_cart=[cart][!]or whatever cart# you're trying to reverse[/!][/text] > > [text show=f]offset_in_seconds=[math][offset]*3600[/math][/text] > [text show=f]offset_as_time=[math time]offset_in_seconds[/math][/text] > [text show=f]scrubbed_cart=[getchars start=1&end=10][your_cart][/getchars][/text] > [text >show=f]days_since_epoch=[math]floor(([scrubbed_cart]+[offset_in_seconds])/86400)[/math][/text] > [text show=f]seconds_since_midnight=[Format >Seconds_To_Time][math][scrubbed_cart]%86400[/math][/format][/text] > > GET DATE & TIME FROM CART #[cart]:
> [math date]{1/1/1970}+{00/[days_since_epoch]/0000}[/math] - > [math time]{[seconds_since_midnight]}-{07:00:00}[/Math] > ================= > > > On Tue, 28 Mar 2006 13:22:22 +0100 > Mark Derrick wrote: >> Several years ago, I vaguely remember someone posting a message with a code sample showing how >>to pull the cart number apart, and produce the date/time it was created - but I can't find the >>posting in the archives - probably due to my poor searching abilities - or SM removing it :-) >> >> I'm looking to analyze incoming cart refs, and check whether they're more than 24 hours old, >>and this seems to be the only way to do this. >> >> Any pointers/tips appreciated. >> >> >> Mark. >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Dan Strong"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Generating unique SKU from [cart] (1997)
Emailer problems solved (1997)
Automatically submitting form with web cat. (2001)
Repeating Fields (1997)
More on the email templates (I like it) (1997)
WebCat2: Items xx to xx shown, etc. (1997)
SKU lookup (1997)
Different Tax levels (1998)
WebDNA Solutions ... sorry! (1997)
OK, here goes... (1997)
Nested tags count question (1997)
Possible Bug in 2.0b15.acgi (1997)
No Data Results (1997)
WebCatalog2 Feature Feedback (1996)
Quitting WebMerchant ? (1997)
New WebDNA Forum Solution (in development) (2003)
More on the email templates (1997)
WebDNA 4.5.1 Now Available (2003)
WebCatalog for guestbook ? (1997)
WebCat2b15MacPlugin - [protect] (1997)