I have 2 columns, [Date] and [Time] in my table.
Date is of form dd.mm.yyyy and type varchar (10).
Time is of form hh:mm and type varchar(5)
For a particular date I want to find the previous date, so for example, for 2014.10.19 I want to find out the previous date which would be 2014.10.18 and that is by doing something like:
PRINT 'some text' + @mydate - 1
It complains about conversion error. I have tried CAST and CONVERT but I still get an error.
I need an expert to show me how to achieve this.