I have an issue with a report, in that it shows the date of when sales were posted, but they were actually processed the previous day. Therefore, I would really like to display the previous date not the date that the sale was recorded.
Dates in my table are in the format YYYYMMDD
How can I change the data via a formula to the proper previous day. (ie 20150901 would change to 20150831 and likewise for March 1 and the proper Feb 29/or 28th.
I am creating a view in SQL so as to not disturb the actual data in the original table.
Thanks very much