Re: Calculating Age from DB fields
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54711
interpreted = N
texte = Hi Glenn, Thanks for the heads up. Working just fine... Have a nice weekend and thanks for the quick assistance... Palle On 6/12-2003, at 16.36, Glenn Busbin wrote: >> Hi all, >> >> Some how my heads isn't working today, so I hope someone will be >> helpful... >> >> I have a profile database with a lot of personal profile info >> including these three fields >> >> db_date (01...31) >> db_month (01...12) >> db_year (1900...2010) >> >> I want to calculate the actual date based on todays date. >> > > You mean you want to calc the *age*, right? > > Use days to date. > > AgeInDays=[Math]([Math]{[Date]}[/Math])-([Math]{[db_month]/[db_date]/ > [db_year]}[/Math])[/Math] > > AgeInYears=[Math]AgeInDays/365.25[/Math] > > ------------------------------------------------------------- > 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/ > > -- Venlig hilsen Palle B. Nielsen (PowerPalle) http://www.macnyt.dk/ ------------------------------------------------------------- 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:
Hi Glenn, Thanks for the heads up. Working just fine... Have a nice weekend and thanks for the quick assistance... Palle On 6/12-2003, at 16.36, Glenn Busbin wrote: >> Hi all, >> >> Some how my heads isn't working today, so I hope someone will be >> helpful... >> >> I have a profile database with a lot of personal profile info >> including these three fields >> >> db_date (01...31) >> db_month (01...12) >> db_year (1900...2010) >> >> I want to calculate the actual date based on todays date. >> > > You mean you want to calc the *age*, right? > > Use days to date. > > AgeInDays=[math]([math]{[date]}[/Math])-([math]{[db_month]/[db_date]/ > [db_year]}[/Math])[/Math] > > AgeInYears=[math]AgeInDays/365.25[/Math] > > ------------------------------------------------------------- > 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/ > > -- Venlig hilsen Palle B. Nielsen (PowerPalle) http://www.macnyt.dk/ ------------------------------------------------------------- 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/
Palle Bo Nielsen
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:
[ot] Stopping Apple's Log Rolling (2004)
[WebDNA] Error 500 with SUMM=T (2017)
Modify Database (1998)
Problem with Formulas.db (1998)
choice of images (2000)
Major Security Hole (1998)
WebCat2 - [format thousands] (1997)
Location of Webcat site in folder hierarchy (1997)
Not really WebCat- (1997)
Webcatalog and IIS4b2 (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
Thanks Grant (1997)
WebCat2 - Getting to the browser's username/password data (1997)
delete and return to founditems (2002)
Search or delete (or date or time) has bugs ... (1998)
Incrementing a number (1998)
Date Range works (1997)
So when do we get something similar? (1998)
[WebDNA] eCommerce in 7.0 but not in 7.1? (2012)
Re: (1997)