> Thanks Rich. Tried to implement but recevd errors with Convert. Where
> does this command go pls? In the where? Tried that but still got
> errors.
Rich noted the example uses MSSQL syntax. I don't know if Access has the
convert() function. I'm kinda' rusty but try one of these two
WHERE dateDiff('d', expiration, date()) = 7
WHERE expiration >= dateAdd('d', -7, date()) AND
expiration < dateAdd('d', -6, date())
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273763
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
