I am currently creating a report for the maxium weeks we can hold a product. When I use the formula Startweek + Holdweeks which equals @MaxHoldWeeks, the year does not start over until it reaches 2004,99 (year,week), but there are only 52 weeks in a year. Therefore the year should start over at 200452 not 200499. Is there anything I can do to fix this problem? and the report must be query by week number
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations danielledunham on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Incorrect week date
- Thread starter jpeepsu
- Start date
Similar threads
- Locked
- Question