Hello,

How to get the week number for a year.??
For example, 29-01-2002, is in week number 5 and 13-03-2002 is in week number 11.

Please help.. It's really urgent..

Thanks a lot..

FYI: i'm using baan iv c2 and using informix database..

Regards,
Parames.s

Dear parames,

Probably you can try num.to.week() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_num_to_week)

Rgds,
Paul

Dear parames,
you can try this

string(2) result
result=sprintf$("%D (%w)",date.num())
here w will return the value for week

hope this will help u

reeta