sorry...shouldn't have had those #s around the right hand sides. fixed
below.
Jim Wright wrote:
>
> You also might want to use the CreateODBCDate function (without the
> time)...with the time part, you will have cases where...
>
> if now() = 11/27/2006 09:46AM and F.filePostDate = 11/6/2006 00:00AM
>
> #CreateODBCDateTime(Now())# <= DateAdd('D',21,F.filePostDate)
>
> will be FALSE
>
> but...
> #CreateODBCDate(Now())# <= DateAdd('D',21,F.filePostDate)
>
> will be TRUE
>
> My guess is that you don't want to take the time into account...but then
> I'm not sure exactly what you are doing.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
