Our database records the weekending (WE) and the day (WORKDAY) our employee (EMPNO) was at the job (JOBNO). Unfortunately, our company has added a twist and starts thier workweek on Wednesdays.
I need a SQL formula that will convert WORKDAY and WE into a date. In Excel "=IF(WORKDAY<3, (WE-2+WORKDAY), (WE-9+WORKDAY))" works.
Also, I need the statement to find the MIN and MAX values in those dates to tell me when we started and finished the job (JOBNO). Any help would be appreciated. I've only been thinking about it for 90 minutes, and my head already hurts....
2006-07-11
05:37:41
·
4 answers
·
asked by
bleme
4
in
Programming & Design