pass sql date in record selector to server

[EBee]

HELP!

after following the faq767-3825 to pass sql date from crystal report -- we are still not able to see the dates from the SHOW SQL query. This means that the filter does not work for the dates needed. Please check our code to see what we are doing wrong.


CR9
SQL server 2k

thank you



Formula Help
Optimizing SQL Pass Through using the Record Selection Formula
faq767-3825


==============================================
{mc_acct_master_view.bus_unit_id} = "MMB" and
{mc_acct_master_view.pub_id} = "MMB" AND
{mc_ad_detail.adv_type} in ["CL", "GC", "CG"] and
not ({mc_ad_cost_view.obj_code} in ["19", "29", "59", "485", "900", "905", "915"]) and
//{mc_ad_insertion.pub_flag} = "Y" and
not ({mc_ad_insertion.prod_code} in ["ELDY"]) AND

(
{mc_ad_insertion.insertion_date} = {@sdate}
)
============================================

== FROMULA ===
@sdate
cdatetime(year({startdate_view.startdate}),month({startdate_view.startdate}), day ({startdate_view.startdate} ),0,0,0)