I have a report written in CR 2011 that I want to automate. In the SQL Query Command I have:
TICKHISD."DtTransDate" >= {d'2020-04-01'} and
I am basically pulling everything from the start of the previous month.
What do I need to do to not have the actual date in the query?