Re: date math

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61838
interpreted = N
texte = Dave, the problem with this is that if a time was appended that is less than the current time, you have a negative integer. This is why, when dealling with Date and Time down to the seconds, you will always do better with "seconds since epoch". Donovan Dave Hurley wrote: > Since you have your date and time fields separated, you may need to > create dates and times with them. By enclosing the whole thing in {} and > setting it as a math variable, it will be in the form of an integer, > which simplifies any calculations: > > [text]Emon=04[/text] > [text]Eday=20[/text] > [text]Eyr=2005[/text] > > [text]EHr=11[/text] > [text]Emin=45[/text] > [text]Esec=45[/text] > > entered date as integer = [Math]Edate={[Emon]/[Eday]/[Eyr]}[/Math] > > entered time as integer = [Math]Etime={[EHr]:[EMin]:[Esec]}[/Math] > > Now do the same for the current date and time: > > today's date as integer = [Math]Tdate={[date]}[/Math] > > today's time as integer = [Math]Ttime={[time]}[/Math] > > Now subtract one from the other: > elapsed days as integer = [Math]elapsedD=[Tdate] - [Edate][/Math]
> > elapsed time as integer = [Math]elapsedT=[Ttime] - [Etime][/Math] > > To convert back to days, hours, minutes and seconds, use the format tag: >
> [elapsedD] days, [Format Seconds_To_Time %H hours, %M minutes and %S > seconds ago.][elapsedT][/Format] > > > Dave Hurley > Biology Department > University of Washington -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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:

    
  1. Re: Date Math broken on Mac OS X 10.4? ( Tom Duke 2007)
  2. Re: Date Math broken on Mac OS X 10.4? ( Paul Willis 2007)
  3. Re: Date Math broken on Mac OS X 10.4? ( Tom Duke 2007)
  4. Date Math broken on Mac OS X 10.4? ( Paul Willis 2007)
  5. Re: Date Math ( Patrick McCormick 2005)
  6. Re: date math ( Donovan Brooke 2005)
  7. Re: date math ( Dave Hurley 2005)
  8. Re: Date Math ( Donovan Brooke 2005)
  9. Re: Date Math ( "Allen" 2005)
  10. Date Math ( Eddie Z 2005)
  11. Re: date math [2.x] (Aaron Lynch 1999)
  12. Re: date math [2.x] (PCS Technical Support 1999)
  13. Re: date math [2.x] (Marty Schmid 1999)
  14. Re: Date Math (Kenneth Grome 1999)
  15. Re: Date Math (Will Starck 1999)
  16. Re: Date math format (PCS Technical Support 1998)
  17. Re: Date Math bug (Dale LaFountain 1998)
  18. Re: Date Math bug (John Hill 1998)
  19. Re: Date math (Michael Winston 1997)
  20. Re: Webcat 2.0.1 date math bug -> Crash! (wahl@dnai.com (Bernt Wahl) 1997)
  21. Re: Webcat 2.0.1 date math bug -> Crash! (Kenneth Grome 1997)
  22. Webcat 2.0.1 date math bug -> Crash! (Dale LaFountain 1997)
  23. Problems with date math (Michael Winston 1997)
  24. Re: Problems with date math (Olin 1997)
  25. Re: Problems with date math (Grant Hulbert 1997)
Dave, the problem with this is that if a time was appended that is less than the current time, you have a negative integer. This is why, when dealling with Date and Time down to the seconds, you will always do better with "seconds since epoch". Donovan Dave Hurley wrote: > Since you have your date and time fields separated, you may need to > create dates and times with them. By enclosing the whole thing in {} and > setting it as a math variable, it will be in the form of an integer, > which simplifies any calculations: > > [text]Emon=04[/text] > [text]Eday=20[/text] > [text]Eyr=2005[/text] > > [text]EHr=11[/text] > [text]Emin=45[/text] > [text]Esec=45[/text] > > entered date as integer = [math]Edate={[Emon]/[Eday]/[Eyr]}[/Math] > > entered time as integer = [math]Etime={[EHr]:[EMin]:[Esec]}[/Math] > > Now do the same for the current date and time: > > today's date as integer = [math]Tdate={[date]}[/Math] > > today's time as integer = [math]Ttime={[time]}[/Math] > > Now subtract one from the other: > elapsed days as integer = [math]elapsedD=[Tdate] - [Edate][/Math]
> > elapsed time as integer = [math]elapsedT=[Ttime] - [Etime][/Math] > > To convert back to days, hours, minutes and seconds, use the format tag: >
> [elapsedD] days, [Format Seconds_To_Time %H hours, %M minutes and %S > seconds ago.][elapsedT][/Format] > > > Dave Hurley > Biology Department > University of Washington -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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:

Cancel Subscription (1996) Summary Searches (2000) 2.1 pricing? (1998) Creating main- and sub-category search (1997) 2.0 Beta (1997) Re1000001: Setting up shop (1997) Setting up shop (1997) date sorting and 'template (1997) Robots fill event log (1997) DB Emergency (2002) Virtual hosting and webcatNT (1997) Configuring E-mail (1997) RE: WebCatalog2 for NT Beta Request (1997) Menu to select product variations (1997) Can [writefile] files be served thru webcat? (2000) WCS Newbie question (1997) listfiles-looking for slick solution (1997) Find all in search. (2002) OK, here goes... (1997) Shipping cost out of synch (1998)