I am building an SQL view which shows me all entries of table T where the information is last month. I want it so that if I run the view any time in August, it will show me all entries for July, not just a month before which is what I have done with my current code.

Please see this:

```
where cast(t.Ticket_OpenDate as date) >= cast(dateadd(month, -1, getdate()) as date)

```

I look forward to hearing from someone.