Re: [WebDNA] add hours over 24

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111486
interpreted = N
texte = --20cf302efbb2c586a504ff659097 Content-Type: text/plain; charset=UTF-8 Steve, You should probably be using epoch time, i.e. seconds since 1970, for the timestamps and then running calculations from there. So the timestamp code is: [math]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math] you can then add / delete seconds from that. Donovan had a bunch of functions for this, he posted the text below back in 2010. The link to the functions isn't working, maybe Donovan you could post a fixed link? - Tom Here's my reference. http://www.euca.us/admin/tests/sectodays.html It's also in my function lib. converted to an easier to use format, Euca Standard WebDNA Extensions V.2.1: http://www.euca.us/index.html?page=dev --20cf302efbb2c586a504ff659097 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Steve,

You should probably be using epo= ch time, i.e. seconds since 1970, for the timestamps and then running calcu= lations from there.

So the timestamp code is: =C2= =A0

= =C2=A0 =C2=A0[m= ath]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math]

you can then add / dele= te seconds from that.

Donovan had a bunch of = functions for this, he posted the text below back in 2010. =C2=A0The link t= o the functions isn't working, maybe Donovan you could post a fixed lin= k?

- Tom



Here's my reference.
http://www.euca= .us/admin/tests/sectodays.html

It&#= 39;s also in my function lib. converted to an easier to use
format, Euca = Standard WebDNA Extensions V.2.1:

<= a href=3D"http://www.euca.us/index.html?page=3Ddev" target=3D"_blank" style= =3D"font-family:arial,sans-serif;font-size:13px">http://www.euca.us/index.h= tml?page=3Ddev




--20cf302efbb2c586a504ff659097-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] add hours over 24 (Terry Wilson 2014)
  2. Re: [WebDNA] add hours over 24 (Donovan Brooke 2014)
  3. Re: [WebDNA] add hours over 24 (Tom Duke 2014)
  4. Re: [WebDNA] add hours over 24 (Steve Braun 2014)
  5. Re: [WebDNA] add hours over 24 (Stuart Tremain 2014)
  6. Re: [WebDNA] add hours over 24 (Steve Braun 2014)
  7. Re: [WebDNA] add hours over 24 (Dan Strong 2014)
  8. [WebDNA] add hours over 24 (Steve Braun 2014)
--20cf302efbb2c586a504ff659097 Content-Type: text/plain; charset=UTF-8 Steve, You should probably be using epoch time, i.e. seconds since 1970, for the timestamps and then running calculations from there. So the timestamp code is: [math]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math] you can then add / delete seconds from that. Donovan had a bunch of functions for this, he posted the text below back in 2010. The link to the functions isn't working, maybe Donovan you could post a fixed link? - Tom Here's my reference. http://www.euca.us/admin/tests/sectodays.html It's also in my function lib. converted to an easier to use format, Euca Standard WebDNA Extensions V.2.1: http://www.euca.us/index.html?page=dev --20cf302efbb2c586a504ff659097 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Steve,

You should probably be using epo= ch time, i.e. seconds since 1970, for the timestamps and then running calcu= lations from there.

So the timestamp code is: =C2= =A0

= =C2=A0 =C2=A0[m= ath]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math]

you can then add / dele= te seconds from that.

Donovan had a bunch of = functions for this, he posted the text below back in 2010. =C2=A0The link t= o the functions isn't working, maybe Donovan you could post a fixed lin= k?

- Tom



Here's my reference.
http://www.euca= .us/admin/tests/sectodays.html

It&#= 39;s also in my function lib. converted to an easier to use
format, Euca = Standard WebDNA Extensions V.2.1:

<= a href=3D"http://www.euca.us/index.html?page=3Ddev" target=3D"_blank" style= =3D"font-family:arial,sans-serif;font-size:13px">http://www.euca.us/index.h= tml?page=3Ddev




--20cf302efbb2c586a504ff659097-- Tom Duke

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:

Fun with Dates (syntax) (2002) Assigning Serialized Customer Numbers (1997) Search design (1997) Viewing old carts (was FEW QUESTIONS) (1997) Cancel Subscription (1996) ListWords passing multi values in one form field (2000) [INCLUDE] Limitations (1998) More Applescript (1997) WCS Newbie question (1997) WebCat2b15MacPlugin - showing [math] (1997) WebCat2 several catalogs? (1997) [LOOKUP] (1997) Two stores, one server (1998) Submitting ampersands in forms... (1998) Slow Code, how to speed up (2002) how is this possible (2000) any ideas on why DOC can't execute an executable? (1998) [WebDNA] Converting a CSV file to a WebDNA db automatically? (2016) Items XX to XX shown (1997) Nested tags count question (1997)