Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to create a derived field and provide values into it through script
Hello 3 Idiots,
perhaps this can serve you as an example:
IF(MONTH(MyDate) <4, 'Q1', IF(MONTH(Mydate) <7, 'Q2', IF(MONTH(MyDate) <10,'Q3', IF(MONTH(MyDate) <13,'Q4', 'Q5')))) AS MyQuarter,
Regards, Roland