Calculating the week number

Hi!!



I would like to calculate number of the week given a specific date. OCONV returns the day of the week and not the week number. If anyone knows how to do this then will you please help me.



Thanks,

Vuyo

E.g.



DATE.IN = TODAY
DATE.IN = ICONV(DATE.IN,'D')
DATE.IN = OCONV(DATE.IN, 'D J')

WEEK.NUM = INT(DATE.IN/7)

IF MOD(DATE.IN,7) THEN WEEK.NUM += 1



Cheers