Help with an Expression Label

[Anonymous]

Hi Guys,

I have the field DAY_RATE brought in via an SQL Load but I want to know is there anyway where I can write an Expression for the DAY_RATE label that:

if END PERIOD (A normal date DD/MM/YYYY) is equal to the period APRIL-OCTOBER it says SUMMER_DAY_RATE or if the END PERIOD is equal to NOVEMBER-MARCH it says WINTER_DAY_RATE.

Regards

[sunny_talwar]

May be this:

LOAD *,

          If(Num(Month([END PERIOD]) >= 4 and Month([END PERIOD] <= 10, 'SUMMER_DAY_RATE', 'WINTER_DAY_RATE')

[Anonymous]

Hi Sunny,

How would this work as an expression in the label tab?

If(Num(Month([END PERIOD]) >= 4 and Month([END PERIOD] <= 10, 'SUMMER_DAY_RATE', 'WINTER_DAY_RATE')

The above alone doesn't seem to be picking it up.