Mark Leder wrote:
> Outstanding! That was it (the filePostDate value not existing problem).
> Thanks Jim and Ryan.
>
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:261722
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
