We use formulas like this for each detail line of labor_dtl record
We use them in CorVu but I think this is the syntax for RB
Week formula - will gave an integer number since 2002
integer((clock_in_date - 12/23/2002) / 7)
Week_to_use - will give the week for the
year 2003, 2004, and 2005
iif(week <= 52, week, iif(week <= 104, week - 52, week - 104))
then sum by week
BW
_________________________________________
Babette Welch
IT Director
Argonics Inc
1110 Wright
Marquette MI 49855
906.226.9747
We use them in CorVu but I think this is the syntax for RB
Week formula - will gave an integer number since 2002
integer((clock_in_date - 12/23/2002) / 7)
Week_to_use - will give the week for the
year 2003, 2004, and 2005
iif(week <= 52, week, iif(week <= 104, week - 52, week - 104))
then sum by week
BW
_________________________________________
Babette Welch
IT Director
Argonics Inc
1110 Wright
Marquette MI 49855
906.226.9747