bet to me. Second to that, add a time portion to the user's value
behind the scenes that will make the comparison do what you want. If
it's a LT comparison, set the time to midnight. If it's a LTE, set
the time to 23:59:59. etc.
I usually do the latter, because the CFCs that house my business logic
assume that everything (well, almost everything) is a datetime value.
So in my UI controller, I tack on the appropriate time portion, and
then pass the full datetime to the backend CFCs.
cheers,
barneyb
On Tue, 24 Aug 2004 18:02:02 -0400, Tangorre, Michael
<[EMAIL PROTECTED]> wrote:
> What is the most efficient way to ignore the time portion of a date
> field in SQL server when making a comparison to a user specified date
> value without a time portion? Wow, that was a mouthful.
>
> Thanks,
>
> Mike
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
