Skip to Content
0
May 20, 2020 at 04:22 PM

SQL Query Begin of Previous Month

422 Views

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?