This content has been marked as final. Show 3 replies
If you provided input data and the corresponding output, what you ask for would be more clear.
Please, don't forget to provide also the structure of the table(s) involved in the operation.
Suggestion is Don't expect us to do your Homework.
876801 wrote:What if the inputol1='S' and the month is 10 ? substracting 6 would never be 1,2 or 3....
If inputcol1 = 'S', then substract 6 to the month of date1 until the result will be '1' or '2' or '3'