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:
redirect with frames (1997)
Secure Sever and showcart errors (1997)
Using Applescript to process WebCatalog functions (1998)
Share cost of training videos! (1998)
Replace Statement (1997)
[delete] problem (1997)
Mac List Servers (was: Duplicate Hell) (1999)
Multiple prices (1997)
(1997)
Comments in db? (1997)
[tcp connect] (1998)
How reliable is WebDNA? (2004)
show me your store ! (2003)
PCS Frames (1997)
[random] only for 1-100??? (1997)
Sorting by type=date (1999)
Possible Bug in 2.0b15.acgi (1997)
Plugin causes type 2 error on WebStar startup (2000)
Unix DB Permission Error (2002)
Exclamation point (1997)