Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have data as below. I want to add new column with the max data for each row. How can I do this:
| DOC | D1 | D2 | D3 | D4 |
| FA_1 | 2014-12-15 | 2014-11-30 | 2014-12-07 | 2014-11-29 |
| FA_2 | 2014-12-05 | 2014-12-13 | 2014-12-04 | |
| FA_3 | 2014-12-25 | 2014-12-24 | 2014-12-26 |

RangeMax(D1,D2,D3,D4) as MaxD
RangeMax(D1,D2,D3,D4) as MaxD