I have a SQL query which outputs dates as a Char field so I can have blank date fields as '' instead of 1900-01-01.
I am trying to write the query so only records with anExpiresDate > getdate() - 19:
However, when the the query runs, I get data for prior years witin the Month and Day period, but for prior years.
What is the syntax to only get data > 7/1/2015 and not anything for July of 2014.
ExpiresDate is stored as Varchar (30).