SQL to Teradata through MS Access


SQL to Teradata through MS Access

Hi I'm new to the teradata world and not all that great with pass through queries. I have a query that I would like to pass to my server but I want to prompt the user for the date before it is submitted. Ultimately I'd like to link that field to an MS Access form text box, but I'll worry about that later. I get a syntax error no matter how I try to phrase the user prompt for the date. Someone told me it was '?' but I can't get that to work either.

part of my query that is not working(Prompting the user)

where (cast(eods_pcc_proddb_v.alpha_channel_summary.snapshot_tms As date) = )

I'd like to replace CURRENT_DATE with a user prompt ot a referemce to an access form named "frmMain".