Week and month data overwritten in the database
-
Weekly and monthly totals are both stored in database with period value of “AAYYYY” where “AA” is week number or month number and “YYYY” is the year number. This creates an overlap for first 12 weeks and months each year. Perhaps the weeks should be stored with 3 digits representing the week number to avoid the collision.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Week and month data overwritten in the database’ is closed to new replies.