Instead of adding tables to my report I've added a command. I'd like to add parameters to the query for the command. When it comes to strings everything is fine. Its dates I'm having problems with. For example:
SELECT name, EndDt from tlb_Name where EndDt <= {?EndDt}
When I try to save the command I get a syntax error or an access violation.
Thoughts?
Thanks in advance.
SELECT name, EndDt from tlb_Name where EndDt <= {?EndDt}
When I try to save the command I get a syntax error or an access violation.
Thoughts?
Thanks in advance.