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 isless 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".DonovanDave 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:
Dave, the problem with this is that if a time was appended that isless 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".DonovanDave 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:
XML and CDATA (2004)
Date/Time format problems (1997)
Search-context (1999)
syntax question, not in online refernce (1997)
Why did this copyfile stop working? (2004)
PSC recommends what date format yr 2000??? (1997)
How Many SKU's is enough? (1997)
Email address checker (2002)
Help need to figure this out today!!! Advanced Question. (2004)
WebCat2: Found Items syntax, etc. (1997)
Absolutely OT: Where's Clearway Technologies? (2000)
SV: Mass Mail (2000)
Searching multiple Databases (1997)
WebCatalog v2.1.1 (1998)
WebCat2: multiple currency support (1997)
ANSWER to: CC Merchant suggestions?? (1997)
no [include]s with encryption? (1998)
searchable list archive (1997)
Ok here is a question? (1997)
2.0 Info (1997)