Hi Is there a date by weeks set up in Baan IV - i.e. can I find a week number and a date range in a Baan table?
Thanks.

Hi Is there a date by weeks set up in Baan IV - i.e. can I find a week number and a date range in a Baan table?
Thanks.

Hello,
there are function like num.to.week() or week.to.num()
to analyse or convert a date.

What do you want to achieve? Bemore specific, please.

Regards

Look at tirou400 and see if it does what you want. You can search by week and year and return the first day or last day of the week depending on the sort in the query.
Example:

select tirou400.*
from tirou400
where tirou400.yrno = :year.f
and tirou400.week = :week.f
order by tirou400.date
as set with 1 rows
selectdo
endselect
start.date = tirou400.date