tw
-----Original Message-----
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Friday, May 28, 2004 10:03 AM
To: CF-Talk
Subject: Re: How do you *manage* time? (Add it, Subtract it, Track it)
> I always use seconds, and build up from there.
> its soo easy to work with them, with dateAdd, and dateDiff.
>
> and as always the database is really thin, since your just storing
numbers.
>
> .02
>
> tw
After I typed this, I had a thought about this more, and thought this:
Why do I need to store the hours as a "date time" object anyway?
If I *only* need to "build" a time in 15 minute increments (.25) would it be
bad practice to store the hours spent as integers and control the input of
the values on the front end CF page? So the dropdown menu would say, "00,
15, 30, 45" but the value would be ".00, .25, .50, .75"? The math works that
way, right? (same problem...(1.75 + 1.75)$10/hr = $35...right?)
It doesn't matter even if someone spends 25 hours on something, it can add
2.5, 2.5, etc 10 times, and get the right total...right?
So I guess what I'm saying is, does it work to also just store them as ints
and let all my CF on the front end control how the data's input?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
