Re: Cart date/time
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66532
interpreted = N
texte = Thanks very much for this - and all the other tips. This gives me plenty to be going on with. Thanks again. Mark. On 28 Mar 2006, at 18:03, 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 > digest@talk.smithmicro.com> >> 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 digest@talk.smithmicro.com> > 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:
Thanks very much for this - and all the other tips. This gives me plenty to be going on with. Thanks again. Mark. On 28 Mar 2006, at 18:03, 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 > digest@talk.smithmicro.com> >> 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 digest@talk.smithmicro.com> > 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/
Mark Derrick
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:
PCS Frames (1997)
Simple way to create unique SKU (1997)
Busy WebCatalog (2000)
WebCatalog can't find database (1997)
retain raw [cart] submitted value (2004)
RE: [WebDNA] Send results to more pages? (2011)
WebMerchant -- Sweeping WebDelivery < 24 hrs (2000)
Search results templates (1996)
Reversed words (1997)
Calendar Snippet Problems (1998)
method of payment (1997)
syntax question, not in online refernce (1997)
Shopping Cart variation... (1997)
Error Lob.db records error message not name (1997)
W* 3.x & WebCat + WebMerchant (1998)
[WebDNA] What Happened To Zero? (2017)
Re:appending to the database (1999)
Re[2]: New syntax feedback for 4.0 (2000)
Separate SSL Server (1997)
Multiple prices (1997)