See if CreateODBCDate works:
http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi49.htm#wp1102341
On May 16, 2007, at 8:12 PM, Gary Strommen wrote:
> Thank you for your reply,
>
> I am using Microsoft Access 2002.
>
> I actually tested something similar (and I did test your code again
> too) but I came up with a different problem both times... I end up
> receiving all the records, not just the ones between the correct
> dates. I can't figure out why.
>
> I ran a test with cfoutput:
>
> <cfoutput>
> dateMin: #dateMin#<br />
> dateMax: #dateMax#<br />
> dateMinNew: #dateMinNew#<br />
> dateMinNew: #dateMaxNew#<br />
> <cfoutput>
>
> and the page returned:
>
> dateMin: 01/01/2007
> dateMax: 03/31/2007
> dateMinNew: {ts '2007-01-01 00:00:00'}
> dateMinNew: {ts '2007-03-31 23:59:59'}
>
> so I know my variables are being set correctly but I keep getting
> incorrect results.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2745
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
