Re: [CODE] cool elapsed function

2012-12-18 Thread J. Landman Gay
On 12/18/12 6:08 PM, David C. wrote: If you must know, I'm tracking the time since I quit smoking. So far, 6 months 18 days. E-cigs work. :) Bravo Jacque! ...I'm so happy whenever I hear the news of someone quitting and am excited for you. Been there, done that, fully understand just how dif

Re: [CODE] cool elapsed function

2012-12-18 Thread David C.
>> >> If you must know, I'm tracking the time since I quit smoking. So far, 6 >> months 18 days. E-cigs work. :) >> Bravo Jacque! ...I'm so happy whenever I hear the news of someone quitting and am excited for you. Been there, done that, fully understand just how difficult it can be. I'm almost

Re: [CODE] cool elapsed function

2012-12-18 Thread Robert Sneidar
CONGRATZ!!! You've come too far to turn back now!!! GO JACQUE! Bob On Dec 18, 2012, at 10:49 AM, J. Landman Gay wrote: > On 12/18/12 11:31 AM, Peter Haworth wrote: >> Hi Jacque, >> I realize not all applications us an sqlite database but for those that do, >> sqlite has extremely powerful date

Re: [CODE] cool elapsed function

2012-12-18 Thread J. Landman Gay
On 12/18/12 11:31 AM, Peter Haworth wrote: Hi Jacque, I realize not all applications us an sqlite database but for those that do, sqlite has extremely powerful date calculation features. Yup, only this is just for me, the start date remains fixed in time, and I just want to occasionally check

Re: [CODE] cool elapsed function

2012-12-18 Thread J. Landman Gay
On 12/18/12 3:08 AM, Ralf Bitter wrote: Hi Jacqueline, may I invite you to check out the rigTimespan() function in the date helper of revIgniter? Thanks Ralf, I'll take a look at this too. I knew someone must have already written something like this, now I have a couple to look at. -- Jacq

Re: [CODE] cool elapsed function

2012-12-18 Thread J. Landman Gay
On 12/18/12 2:38 AM, FlexibleLearning.com wrote: From The Scripter's Scrapbook... FUNCTION calcAccAge tBirthdate,tAsOf Cool, thanks very much! -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com ___

Re: [CODE] cool elapsed function

2012-12-18 Thread Peter Haworth
Hi Jacque, I realize not all applications us an sqlite database but for those that do, sqlite has extremely powerful date calculation features. Space prohibits going into all the details but here's a few examples. To get the number of days between two dates: SELECT julianday('now') - julianday('1

Re: [CODE] cool elapsed function

2012-12-18 Thread Ralf Bitter
Hi Jacqueline, may I invite you to check out the rigTimespan() function in the date helper of revIgniter? You would have to comment out the line "get rigLangLoadLang("date")" and to replace all calls to rigLangLangLine() with whatever time labeling you need. Ralf On 18.12.2012, at 03:55, J. L

Re: [CODE] cool elapsed function

2012-12-18 Thread FlexibleLearning.com
> On 12/17/12 10:46 AM, Andre Garzia wrote: > > > the function is called elapsed and you can use it to figure out if a > > certain amount of time passed between two timestamps. > Jacquie wrote... > I'd like a function that returns years, months, and days elapsed. I > wrote a quick one that gets th

Re: [CODE] cool elapsed function

2012-12-17 Thread Mark Wieder
Jacque- Monday, December 17, 2012, 9:44:04 PM, you wrote: > On 12/17/12 11:39 PM, Jerry Jensen wrote: >> On Dec 17, 2012, at 9:29 PM, Mark Wieder wrote: >> >>> Jacque- >>> >>> Monday, December 17, 2012, 6:55:20 PM, you wrote: >>> I'd like a function that returns years, months, and days elap

Re: [CODE] cool elapsed function

2012-12-17 Thread J. Landman Gay
On 12/17/12 11:39 PM, Jerry Jensen wrote: On Dec 17, 2012, at 9:29 PM, Mark Wieder wrote: Jacque- Monday, December 17, 2012, 6:55:20 PM, you wrote: I'd like a function that returns years, months, and days elapsed. I I'd like one that calculates gray hair as a function of lines of code.

Re: [CODE] cool elapsed function

2012-12-17 Thread Jerry Jensen
On Dec 17, 2012, at 9:29 PM, Mark Wieder wrote: > Jacque- > > Monday, December 17, 2012, 6:55:20 PM, you wrote: > >> I'd like a function that returns years, months, and days elapsed. I > > I'd like one that calculates gray hair as a function of lines of code. So I should stop with the comment

Re: [CODE] cool elapsed function

2012-12-17 Thread Mark Wieder
Jacque- Monday, December 17, 2012, 6:55:20 PM, you wrote: > I'd like a function that returns years, months, and days elapsed. I I'd like one that calculates gray hair as a function of lines of code. -- -Mark Wieder mwie...@ahsoftware.net ___ use-l

Re: [CODE] cool elapsed function

2012-12-17 Thread J. Landman Gay
On 12/17/12 10:46 AM, Andre Garzia wrote: the function is called elapsed and you can use it to figure out if a certain amount of time passed between two timestamps. I'd like a function that returns years, months, and days elapsed. I wrote a quick one that gets the number of days and divides b