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:
Fun with Dates - finally resolved but.... (1997)
Not reading code (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Initiating NewCart (1997)
Need something like [listchars] ... (2000)
Filemaker Pro & Webcatalog (1999)
Message Boards (2003)
No answers by SM? (2000)
counting characters and/or words (1997)
RE:formula.db problems (1999)
Cant open pages generated by Webcat (2004)
using showpage and showcart commands (1996)
Non-WebDNA Sites Reporting Errors When WebDNA Isn't Running (2006)
Limit to Field Length in DB (1998)
WebCat2 Append problem (B14Macacgi) (1997)
Re:multiple digests, please stop (1997)
Disappearing records (2002)
WebCat2 - many [carts] on one template page? (1997)
Dates - Search and Sorting (1999)
displaying New products (Yikes! it's Fixed!) (1997)