create a derived field

[#1]

how to create a derived field and provide values into it through script

[#2]

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