I have a date in the format of YYYYMMDD, i need to create 2 variables, one with the max date (easy), and the next with the day before, i cannot simply calculate it because the 1st will always end up with zero's, eg: 20160201 would be present day and 20160200 would end up as previous day.
so in my mind convert the number to a date and then do the calculation but there is no date add functionality (similar to month add)
