Re: date math
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61837
interpreted = N
texte = 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 > From: Eddie Z
> Date: April 20, 2005 3:05:10 PM PDT > Subject: Date Math > > > I'm really bad at using the date math features of WebDNA for some > reason. > Maybe someone could help me out. I am adding a countdown feature to my > site > and I need to know how much time there is in between the date of a > page load > and a date read from a database in years, months, days, hours, minutes > and > seconds. > > My database is broken down as follows: > ID# > Eyr > Emon > Eday > Ehr > Emin > Esec > > I've been working with the WebDNA Technical Reference all afternoon > and have > been unable to get the results I need. The only other way I can think > to do > it is by using a bunch of if/then statements. There must be an easier > way. > > Thanks, > Eddie ------------------------------------------------------------- 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:
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 > From: Eddie Z > Date: April 20, 2005 3:05:10 PM PDT > Subject: Date Math > > > I'm really bad at using the date math features of WebDNA for some > reason. > Maybe someone could help me out. I am adding a countdown feature to my > site > and I need to know how much time there is in between the date of a > page load > and a date read from a database in years, months, days, hours, minutes > and > seconds. > > My database is broken down as follows: > ID# > Eyr > Emon > Eday > Ehr > Emin > Esec > > I've been working with the WebDNA Technical Reference all afternoon > and have > been unable to get the results I need. The only other way I can think > to do > it is by using a bunch of if/then statements. There must be an easier > way. > > Thanks, > Eddie ------------------------------------------------------------- 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/
Dave Hurley
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:
HELP-1!!! (1998)
Shopping carts and reloading pages (1997)
request for string functions (1998)
TCPconnect in a DB? (1999)
Corrupt Database Problem... (2000)
Off Topic - OS X web server, FTP accounts (2003)
Rename file (2005)
Multiple Pulldowns (1997)
error count with $purchase (1997)
Sorting problem (2002)
Frames and WebCat (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
F2 to F3 rocky transition (1997)
unsubscribe (1997)
WC Database Format (1997)
[WebDNA] Version 7.x: webdna.ini and EmailerPrefs (2012)
WebStar Directory Indexer (was:hidden databases) (2000)
Nested [tags] (2001)
passing info to thankyou.tpl (1998)
Car Database (2002)